Conditional formatting based on dynamic values

[avelio]

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%
12%	9.7%	15%
12%	21.4%	20%

I'm trying to do the follownig: Conditional format if:

OCR  < Lowbound = GREEN

OCR  >= Lowbound  and <= Highbound = YELLOW

OCR > Highbound = RED

Is there any possibility to accomplish this?

Because using the default conditional formatting in PowerBI does not work since the values are dynamic and can change for each line.

Thank you!

[anazammar]

Hi, 

I want calculate SLA % 

we have a column called ticket,SLA month wise . i want to calculate month wise SLA % 

[v-sihou-msft · Accepted solution]

@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]

@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.

[avelio]

Thank you Simon!

You've been of great help.

BR