| 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... |
Author articles
- 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
Most Popular
- 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?
