Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Conditional formatting with dynamic min and max

Hello, I need to design a report where I need to put a table which will show: 1. Date_time (Date and time when the record has been captured) 2. Value 1 3. Value 2 . . . 11. Value 10 Also I have min an...
  • v-cherch-msft's avatar
    v-cherch-msft
    7 years ago

    Hi Anonymous

     

    You may create a measure and use it for 'Rules' as below picture. Attached the sample file for your reference.

    Measure =
IF (
    MAX ( ConditionTable[Value] ) < [Value1_min],
    1,
    IF ( MAX ( ConditionTable[Value] ) > [Value1_max], 2, 3 )
)

     

    Regards,

    Cherie

v-cherch-msft's avatar
v-cherch-msft
Microsoft Employee
7 years ago

Hi Anonymous

 

You may create a measure and use it for 'Rules' as below picture. Attached the sample file for your reference.

Measure =
IF (
    MAX ( ConditionTable[Value] ) < [Value1_min],
    1,
    IF ( MAX ( ConditionTable[Value] ) > [Value1_max], 2, 3 )
)

 

Regards,

Cherie

AgustinBrocardo's avatar
AgustinBrocardo
Frequent Visitor
4 years ago

Hi v-cherch-msft 

 

I was trying to do the same but with gradient style of formatting. Is there any way in which i can set a variable limit for the gradient?

 

Thanks!