Forum Discussion
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% |
| 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!
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,
4 Replies
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,
Thank you Simon!
You've been of great help.
BR
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.
Hi,
I want calculate SLA %
we have a column called ticket,SLA month wise . i want to calculate month wise SLA %
