Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
sriramk
Helper I
Helper I

Color scaling on percentage of column total for matrix table

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):

 

sriramk_0-1670581183010.png

 

 

Desired result:

 

sriramk_1-1670581183581.png

 

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!

2 ACCEPTED SOLUTIONS
PhillipB
Frequent Visitor

Hi @sriramk 

 

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

 

Screenshot 2022-12-09 115412.png

 

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

 

 

 

 

View solution in original post

PhillipB
Frequent Visitor

Hi@sriramk 

 

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

 

filtering.png

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.

 

theme.png

 

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

 

 

View solution in original post

3 REPLIES 3
PhillipB
Frequent Visitor

Hi@sriramk 

 

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

 

filtering.png

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.

 

theme.png

 

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
Frequent Visitor

Hi @sriramk 

 

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

 

Screenshot 2022-12-09 115412.png

 

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

 

 

 

 

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.

sriramk_0-1670587906075.png

 

Please suggest!

Helpful resources

Announcements
PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors