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 creating a calculated column for each, but struggling with doing it as a measure so that it updates each time the parameter value is changed?

 

So with the sample below if a user selected 35 I want all of the values below 35 in each of the 3 column to be highlighted red.

 

Any pointers would be much appreciated.

 

 

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

3 Replies

  • Fowmy's avatar
    Fowmy
    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" )
  • easton16's avatar
    easton16
    Frequent Visitor
    4 years ago

    Thanks Fowmy  I was overcomplicated it by thinking that SUM would add the column up and not apply it row by row, which of course is what it would do!

  • 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 !