Page filter with conditional formatting

[Jansco]

Is it possible to create a page filter for a table that conditionally formats a field? The user would be able to choose a value and all values below their selected value would turn red.

[v-frfei-msft · Accepted solution]

Hi @Jansco ,

We can create a measure as below and set conditional formatting based on it.

Measure = IF(MAX(Parameter[Parameter]) > MAX('Table'[value]),"#FF000F",BLANK())

[Greg_Deckler]

Yes. I actually do exactly this in my upcoming book, Learn Power BI from Packt publishing. (Sorry, not out until September). The trick is to first use a What If measure. Once you have that, you can create another measure to base your conditional formatting on. Basically use MAX or SELECTEDVALUE to grab the value of your slicer and compare it with the other value you have in the current context. Return something like 1 if higher and 0 if lower. Define your conditional formatting rules on this measure.