Forum Discussion

Namoh's avatar
Namoh
Post Partisan
5 years ago
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...
Need Help
Show and Tell
  • v-lili6-msft's avatar
    v-lili6-msft
    5 years ago

    hi Namoh 

     

    here still is Number instead of Percent

     

    Regards,

    Lin

Namoh's avatar
Namoh
Post Partisan
5 years ago

Thanks, will try to use the extra measure!

 

Will post if it worked.

Namoh's avatar
Namoh
Post Partisan
5 years ago

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....?

 

  • v-lili6-msft's avatar
    v-lili6-msft
    Community Support
    5 years ago

    hi Namoh 

     

    here still is Number instead of Percent

     

    Regards,

    Lin

    • Namoh's avatar
      Namoh
      Post Partisan
      5 years ago

      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.