Forum Discussion
Conditional format in matrix table can't exceed 100% (when using measures)
hi Namoh
you must know that the way the "Percent" conditional formatting works is different than you think, it doesn't have anything to do with percent of total. It take the lowest and hightest displayed amounts and uses those to determine the formatting bands based on the Percent you entered so your table is looking at these numbers to apply the formatting.
So for your case, just replace "Percent" with "Number"
Regards,
Lin
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
I'm sorry i don't know this language in the picture, could you please share your sample pbix for us have a test, that will be a great help.
Regards,
Lin
Hi v-lili6-msft, I found the option to change to English.
Hereby the screenshot in English, hope this helps.
Unfortunately my pbix contains lots of classified info, so I can't share it, but I hope above information is enough.
If more is needed, just let me know.
Don't know if it matters, but the columns in my table are measures.
hi Namoh
From the picture, this result is right for your setting.
you are doing conditional format for actual unplanned downtime(hrs) based on target unplanned downtime(hrs).
so it is right result.
what is your expected output?
Regards,
Lin
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....?