Quick post today because, well, even more going on than usual. This is actually the fifth post on this specific topic, which means that it’s something that keeps coming up. But unlike previous posts, in which we kept DISCOVERING slightly…
The Pivot Pictured Above Acts as if We’ve Swapped Out Fields on Rows – in Response to a Slicer Click! First off…my first post! Being one of the newest (and youngest) members of the PowerPivotPro family has been very exciting…
Have you Heard This Joke: Gil, Austin, and Rob (left to right) Walk Into a Bar…(Yes, Rob’s hair was purple at the time.)(Note from Rob: and it’s still purple today!) Intro from Rob Well folks it’s an exciting time to…
by Matt Allington Recently I have been building some interactive charts for one of my clients using techniques that I have learnt from powerpivotpro.com, from searching the Web, as well as some of my own ideas. While some of the…
Back from Paradise, Here’s a Quick Tip
Funny thing about vacations is that everyone is waiting on you when you get home. But man, what a vacation.
Anyway, I’m juggling my final edits to Alchemy, spending two full days with a client, AND teaching a class on Wednesday/Thursday, so today’s post will be brief, but hopefully still useful:
PivotTable with Two Slicers. Gender Slicer “Cross Filters” the Customer Name Slicer,
As Expected. All is Right with the World.
Now we convert the pivot to cube formulas:
And look what happens to the cross filtering:
In this Report, We Are Only Seeing Customers Who Have Purchased
Both Accessories AND Clothing During 2004
A Post From Oceanside!
Yeah, I’m on vacation (my first real vacation in 5+ years), so why am I writing a post? Well, it’s before 9 am, the family is still sleeping in, and I honestly loved the idea of slipping out to write a post while looking at the ocean.
The truth is I LOVE writing these posts – in some sense they represent Peak Fun for me, especially when they can be written at a relaxed pace with no outside pressures. In the future, maybe I will take vacations for the express purpose of writing. (That sounds surprisingly good to me actually).
Slicers – The More You Select, the More You “Get”
Two Weeks of Refreshes Later… the Report Still Thinks
Nov 15 is What Everyone Wants to See First!
Your Dashboard is Refreshed, But its Slicers are Stuck in “Yesteryear”
This is a trick I’ve been using forever but never blogged about. Enough of you are now using Power Pivot for SharePoint (PP Server) that its time has come. And really, it’s relevant on the desktop too.
On the day you first made this report, you selected the most recent Date (or Week, etc.) in the slicer. And you saved the report. All was right with the world!
But then, tomorrow comes. And all of your slicers still have that “old” date selected, even after you refresh everything. Ick. Who wants to go and update all of those slicers to point to the latest date?
I sure don’t. So, like me, you just let them sit on an old date (or Week, Month, etc.) This forces the consumers of that report to ALWAYS click the latest date, sometimes after scrolling the slicer to the bottom. Every time they open the report. They. Don’t. Like. That. And neither would you.
Guest Post by Jeff Lingen [LinkedIn]
We don’t even know what it is yet. We don’t know what it is. We don’t know what it can be, we don’t know what it will be, we know that it is cool.
Zuckerberg’s early assessment of Facebook was a lot like how I felt after first discovering PowerPivot 3+ years ago. I knew it was cool but had no idea how it would fit into an enterprise business intelligence environment. For a long time PowerPivot for me was just a cool thing that I used for my own data analysis or for proto-typing tools that I would eventually turn into “enterprise-level” solutions. Today I need a pretty compelling reason not to use PowerPivot for almost all of my organization’s analytic requirements. So where does PowerPivot fit into the enterprise BI environment and how do you get associates engaged and use it to provide value?
Thursday’s Post “Fixed” The Number of Negative Stores for a Month at 8.
Now We Vary That Threshold That With a Slicer.
Let’s take Thursday’s post and extend it a bit.
In the picture above you’ll see that I have 5 selected as my threshold on the new slicer, and 48 months “qualify” for that threshold – there are 48 months where at least 5 stores were negative.
Now let me select 9 on the threshold slicer:
Raising the Threshold to 9 Weeds Out 10 More Months, Only 38 Months Exhibited 9+ Negative Stores
How’d I Do This?
Today we have a new guest poster – Miguel Escobar. I’ve been talking to Miguel in email and Skype for a long time now and feel silly that I haven’t asked him to do a guest post until today. But now, I have, so I can stop feeling silly.
From his writing style and creative approach to solving problems, I think you’ll see that he fits right in.
Cool trick: Always show Yesterday’s, Today’s or Tomorrow’s Data
Executive: Are these values correct?
Excel-guy: yes, but you need to check the dates slicers to see what dates the report is using
Executive: Ugh… I just want to click on the report and see the latest values
If you ever had this situation before let me tell you that you’re not alone on that one…I’ve been there before and it’s time to give you some cool easy tricks on how to set up a Powerpivot report that shows you the yesterday, todays, tomorrow, next week or any type of timeframe (forecasting or that sort of scenario).