Forum Discussion

easton16's avatar
easton16
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...
Need Help
  • Fowmy's avatar
    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" )
Anonymous's avatar
Anonymous
Not applicable
3 years ago

I wonder what to do if we have 15 different columns(15 different measures) in a table visual that require conditional formatting with a same rule of values. Writing 15 measures for dynamic coloring is not wise. 


I don't think we can dymincally reference table visual column header and change feild used in measure. 

Hope I'm clear !