Forum Discussion
Conditional format in matrix table can't exceed 100% (when using measures)
Hi v-lili6-msft, thanks for your reply.
I tried your suggestion to use Number instead of Percentage and although I get different colors, they're not as they should be.
First picture is what I've entered, second picture is what it shows.
As you can see, the colors are not according to what I want. Picture 3 shows the current colors (2nd column) and what they should be (4th column), for the first 10 rows op picture 2.
I can't figure out what the logic is that's used to determine the colors, so I could adjust accordingly to get what I want.
PowerBi must be able to provide a simple Conditional Formatting like excel, right...??
If my Actuals are <80% of my Targets, the Actuals should be Dark Green.
If my Actuals are >80% and <110% of my Targets, the Actuals should be Light Green
If my Actuals are >110% and <120% of my Targets, the Actuals should be Orange
If my Actuals are >120% of my Targets, the Actuals should be Red.
How to make this happen in PowerBi?
hi Namoh
You should create a measure as below:
Measure = DIVIDE(SUM(actual unplanned downtime(hrs)) , SUM(target unplanned downtime(hrs)))then do conditional format based on this measure not target unplanned downtime(hrs).
and since this meausre is a percent, you need to change 1->0.01 80->0.8 110->1.1 120->1.2 9999->99
Now it should work for your requirement.
Regards,
Lin
Thanks, will try to use the extra measure!
Will post if it worked.
v-lili6-msft , I've created the measure and it shows the correct values, see 2nd picture below, last column.
I've added the conditional formatting rules accordingly, but the colors are not showing up correctly, see picture below.
What am I doing wrong?
According to above rules the first 3 rows should be Dark Green, because they're less than 80% / 0.8, but they show as Red....?