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

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

    Hi Anonymous

     

    Could you tell me if your problem has been solved? If it is,kindly mark the helpful answer as a solution and welcome to share your own solution. More people will benefit from here. If not, please share more details for us so that we could help further on it.

     

    Regards,

    Cherie

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Many thanks Cherie,

     

    This looks to work in a calculated column 

     

    Calc. column= if([value]<[value_min], 1, if([value]>[value_max],2,3))

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