Color scaling on percentage of column total for matrix table

[sriramk]

Hi Experts!

I am trying to colour scale based on values. When I apply conditional formatting, it is applying on the whole of the values in the Matrix table. Looking for a solution which applies colour scaling based on column specific values. Sample data can be seen in image below for understanding.  Actual .pbix file is available in the url below:

Sample example:

Result of work done(not an expected result):

Desired result:

Actual file:

PBIX file is available at https://drive.google.com/file/d/1BMTfEw485QsAdUvMM9Y5mqhQQ1gIt_0Y/view?usp=sharing

My desired result should be colour scaled on percentage of "column total (%CT) of Average of Yield Capacity"(instead of only "Yield Capacity").

Thank you for your support in advance!

[PhillipB · Accepted solution]

Hi @sriramk 

You can set the properties for the whole visual of the matrix.

By not selecting a specific row of data you will effect all of the elements

[PhillipB · Accepted solution]

Hi@sriramk 

The issue seems to be that there is additional information in the columns that is throwing off the formatting rules.

If you then set the formatting again with the defaults but instead of modifying the function you can modify the theme colours to display the red - green scale.

As soon as you try to modify the function I am having the same problem as you and it then formats by column but not the matrix as a whole

[PhillipB · Accepted solution]

Hi @sriramk 

You can set the properties for the whole visual of the matrix.

By not selecting a specific row of data you will effect all of the elements

[sriramk]

Hi PhillipB,

Thank you for your response! I tried this but however it is not successful. In my case, cell element is diabled as seen in below image.

Please suggest!