Forum Discussion

Jansco's avatar
Jansco
Helper I
7 years ago
Solved

Page filter with conditional formatting

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.
Need Help
  • v-frfei-msft's avatar
    v-frfei-msft
    6 years ago

    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())

     

v-frfei-msft's avatar
v-frfei-msft
Community Support
6 years ago

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())