|KPI's in PowerPivot V2|
|Written by Rob Collie|
|Thursday, 31 May 2012 17:55|
On Tuesday, in my intro to David Hager's post, I promised to circle back "later today" and add some follow-on thoughts. Well, ONE of those words ended up being truthful
But I'm back today! Let's not dwell on the past shall we?
In David's post, he ended up with a "TestStatus" column set to Pass/Fail/Warning depending on a) what the test value reported and b) the specific acceptable ranges established for that particular kind of test.
He was then able to use that as a slicer. But what about conditional formatting? His original example, a regular (non-pivot) table, DID include conditional formatting.Read more...
- Pareto Analysis the Easy Way
- Adding a Minimum Threshold Slicer to "Stores That went negative" Technique
- Showing Only Months/Weeks/Etc. When at Least N Stores Showed a Certain Behavior
- Named Sets and "Asymmetric" Pivots: Showing Different Measures for Different Years
- Toggling Conditional Formatting On/Off via Slicer
- Step by step guide on installing PowerPivot for SharePoint on a single machine
- List of suggested datasets to test PowerPivot
- How to install PowerPivot for Excel and list of know issues
- List of PowerPivot DAX functions with description
- Microsoft Virtual Lab: PowerPivot for Excel 2010 Introduction
- Learning PowerPivot and DAX
- List of PowerPivot DAX functions (short)
- PowerPivot's impact on BI pros?