I don’t exactly have many conferences to compare this one (PASS Business Analytics) to. Also, I’m not sure it is proper to end a sentence with the word “to”. But this was basically my first conference. It was basically fantastic. Proof: Come on! Do we look crazy happy or what!? An amazing set of dudes here – Chandoo, Rob Collie, Matt Allington, myself, and Ken Puls. The “networking” was super fun, and the chance to chat for a few with Marco Russo, Mr Excel, Jen Stirrup, Jen Underwood, Continue Reading
Dynamically changing chart axis
I have been sitting on this post for awhile (that looks weird in one word – should that be “a while”? Let’s just skip that discussion). Okay, I got distracted and was wondering how long I was sitting on this… and it looks like this thread over on the Mr Excel forums came back to life about a month ago and got me thinking about it... The goal is to have charts where the axis/labels/columns/whatever can change via a slicer. So, instead of showing Sales across Years, I can flip and show Sales Continue Reading
Nested Measure Performance
Thanks to SimonNU at the Mr Excel Power BI forums for this question: Would a measure process slower if there are many embedded measures inside of it? A basic example for illustrative purposes: which would be a quicker measure for [Bikes]: 1. Generic Amount:=SUM([Col a]) Bikes:= CALCULATE([Generic Amount],[Col b] = "Bikes") 2. Bikes:= CALCULATE(SUM([Col a]),[Col b] = "Bikes") I admit I have had the same question, but so far properly suppressed it, but… fine, since you asked, let’s Continue Reading
Power Update
If you read my blog, there is a 95% chance you also read the blog over at PowerPivotPro, but if you haven’t seen their announcement, feel free to head on over! Come back for my thoughts: http://www.powerpivotpro.com/2015/02/introducing-power-update/ There is a bunch of questions I ask new clients… about the size and nature of their data, how they get final reports out to the folks that want to see them, etc. And there is a lot of dancing around this theme of “how and when Continue Reading