Forum Discussion

Frequent Visitor

4 years ago

Solved

Dynamic Conditional Formatting of 3 table column values based on value of what if parameter value

I am trying to get 3 columns in a table (call it 'Table1' in this case) to dynamically conditional format based on 'what if value parameter seleceted' ('TemperatureFilter') I can do this by creat...

Fowmy
4 years ago
easton16

Create three measures for each column and assign them as Field Value under conditional formating

Hope you have the simple measures created for each column and a parameter

Example:

CF 20M = IF( [Sum of 20M] < [Parameter Value] , "red" )

Super User

4 years ago

easton16

Create three measures for each column and assign them as Field Value under conditional formating

Hope you have the simple measures created for each column and a parameter

Example:

CF 20M = IF( [Sum of 20M] < [Parameter Value] , "red" )