Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Solved! Go to Solution.
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,
Hi,
I want calculate SLA %
we have a column called ticket,SLA month wise . i want to calculate month wise SLA %
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 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.
Thank you Simon!
You've been of great help.
BR
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |