Forum Discussion

avelio's avatar
avelio
Helper II
9 years ago
Solved

Conditional formatting based on dynamic values

Dears,   I'm trying to color some percentages in a matrix chart.   My data looks like this:   LowBound OCR HighBound 12% 20.8% 15% 7% 8.8% 9% 12% 11.7% 20% 12% 12.6% 20...
Need Help
Tips and Tricks
  • v-sihou-msft's avatar
    v-sihou-msft
    9 years ago

    avelio

     

    Currently it's not supported to dynamically configure condition formatting on the OCR column since we can't add field value in conditional formatting. And it's not supported to set conditional formatting based on another column.

     

    So you may add another column to assign static value and configure conditional formatting on that column.

     

    Tag =
IF (
    Table1[OCR] < Table1[LowBound],
    1,
    IF (
        Table1[OCR] >= Table1[LowBound]
            && Table1[OCR] <= Table1[HighBound],
        0,
        -1
    )
)

     

     

     

     

     

    Regards,

v-sihou-msft's avatar
v-sihou-msft
Microsoft Employee
9 years ago

avelio

 

Currently it's not supported to dynamically configure condition formatting on the OCR column since we can't add field value in conditional formatting. And it's not supported to set conditional formatting based on another column.

 

So you may add another column to assign static value and configure conditional formatting on that column.

 

Tag =
IF (
    Table1[OCR] < Table1[LowBound],
    1,
    IF (
        Table1[OCR] >= Table1[LowBound]
            && Table1[OCR] <= Table1[HighBound],
        0,
        -1
    )
)

 

 

 

 

 

Regards,

Jkaelin's avatar
Jkaelin
Resolver I
9 years ago

v-sihou-msft This is great help.  At my firm, we have a core report that is directly color coded based on dynamic values.  This functionality would be great in a future release & drive Power BI adoption for our firm.