cancel
Showing results for 
Search instead for 
Did you mean: 
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
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

BizApps LATAM 2023

Business Application LATAM Summit 2023

Join the biggest FREE Business Applications Event in LATAM this February.

Power Platform Bootcamp

Global Power Platform Bootcamp

In this bootcamp we will deep-dive into Microsoft’s Power Platform stack with hands-on sessions and labs, delivered to you by experts and community leaders.