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

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.