Forum Discussion

Namoh's avatar
Namoh
Icon for Post Partisan rankPost 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
Icon for Community Support rankCommunity Support
5 years ago

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

Namoh's avatar
Namoh
Icon for Post Partisan rankPost Partisan
5 years ago

Thanks, will try to use the extra measure!

 

Will post if it worked.

  • Namoh's avatar
    Namoh
    Icon for Post Partisan rankPost 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
      Icon for Community Support rankCommunity Support
      5 years ago

      hi Namoh 

       

      here still is Number instead of Percent

       

      Regards,

      Lin

      • Namoh's avatar
        Namoh
        Icon for Post Partisan rankPost 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.