Conditional Formatting via Slicers, Part Two
User Rating: / 0
PoorBest 
Written by Rob Collie   
Thursday, 04 October 2012 19:28

In the last post on this topic, I discovered what I think is a bug in Excel 2010 conditional formatting, one that prevented me from using the Percentile threshold type with a cell reference.

But the Number type works great, so if I can get the actual [Profit] value for, say, the 80th percentile Model Name into a cell, I can reference that.

And that's precisely what those three cells in the image above contain:

Read more...

 

Tags: dax, excel, tabular
 

XL Cubed