Forum Discussion
Conditional format in matrix table can't exceed 100% (when using measures)
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 v-lili6-msft , thanks I now realise that it looks at the value of my Target values.
But this is not what I want.
I want the following:
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.
So first row Target is 95 Actual is 62, Actual is <80% of Target so this should be Dark Green.
I expect colors like the 4th column (D) in below picture according to above 4 rules.
Column C shows the percentage of Actual compared to the Target, column D shows the color that I would like to be returned.