Forum Discussion
Solved
Conditional format in matrix table can't exceed 100% (when using measures)
Hi, I've got a matrix table with 4 columns. I would like to color two of these columns (based on the other two columns) via conditional formatting. The colors should be shown via the followi...
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....?
Yes, that solved it.
To be honest the Conditional Formatting this works in PowerBi is much less intuitive then how it works in Excel.
The fact that you need to create an extra measure is a step I really don't understand, with my knowledge from Excel.
But then again, I'm a newbie when it comes to PowerBi, but it just isn't as easy and intuitive as Excel.