Column specific color scaling in Matrix table

Question

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. Thank you for your support in advance!&nbsp;Result of work done(not an expected result):&nbsp;&nbsp;Desired result:&nbsp;&nbsp;

samarth_18 · Answer

Hi&nbsp;sriramk&nbsp;,
&nbsp;
YOu could refer to below articlehttps://learn.microsoft.com/en-us/power-bi/create-reports/desktop-conditional-table-formatting&nbsp;

sriramk · Answer

Thank you. I tried this but somehow I am missing.

samarth_18 · Answer

Could you please explain the issue or share the PBIX file after removing sensitive data?

sriramk · Answer

Hi, My desired result should be colour scaled on percentage of "column total (%CT) of Average of Yield Capacity"(instead of only "Yield Capacity").For example: "Prod18" &amp; "Prod39" are also performing good with their own capacity similar to other Prod's but colour scale shows complete red color.&nbsp;&nbsp;PBIX file is available at&nbsp;https://drive.google.com/file/d/1BMTfEw485QsAdUvMM9Y5mqhQQ1gIt_0Y/view?usp=sharing&nbsp;.&nbsp;&nbsp;Thanks for your solution in advance!

Forum Discussion

Column specific color scaling in Matrix table

4 Replies

Related content

Warehouse Scaling

Wrap text in specific columns?

Updating specific columns

Specific matrix

Sorting specific column in matrix visual