cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Ubo-Pakes Frequent Visitor
Frequent Visitor

Column colors based on header, not on content

Dear all,

 

I am working with school data on sanitation and cleanliness and we are now starting to use PowerBi to analyze and present the data. We have a matrix in PwerBI based on a column with 5 values:

NP, no star, 1 star, 2 stars, 3 stars.

 

For each of these values, I present the number of schools that comply to this condition and the row percentage. The table looks like this: 

Capture.PNGmatrix example

What I would like to, but can not find is to give background colors on the columns, based on their header and not on the values inside the matrix. So for NP I would like to the two colums (# schools and % schools), to be colored grey, for no stars, red, 1 star yellow etc ..

Anyone has some suggestions on how to do this?

 

Thanks

 

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Column colors based on header, not on content

Hi @Ubo-Pakes 

 

You can create a measure like below and later use it for conditional formatting in your Matrix Visual.

conditional formating = 
VAR _sv = SELECTEDVALUE( 'Table'[Category] )
RETURN 
SWITCH(
    TRUE(),
    _sv = "NP", 1,
    _sv = "no star", 2,
    _sv = "1 star", 3
)

This is how you set up Conditional Formating on Value fields in your Matrix.

image.png

 
Please see the attached file for reference.
Hope this helps!
 
Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
Mariusz Repczynski

 

View solution in original post

2 REPLIES 2
Super User
Super User

Re: Column colors based on header, not on content

Hi @Ubo-Pakes 

 

You can create a measure like below and later use it for conditional formatting in your Matrix Visual.

conditional formating = 
VAR _sv = SELECTEDVALUE( 'Table'[Category] )
RETURN 
SWITCH(
    TRUE(),
    _sv = "NP", 1,
    _sv = "no star", 2,
    _sv = "1 star", 3
)

This is how you set up Conditional Formating on Value fields in your Matrix.

image.png

 
Please see the attached file for reference.
Hope this helps!
 
Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
Mariusz Repczynski

 

View solution in original post

Highlighted
Ubo-Pakes Frequent Visitor
Frequent Visitor

Re: Column colors based on header, not on content

Dear Mariusz,

 

just what the doctor ordered! Works like a charm,  

 

Thanks ...

 

Ubo

Helpful resources

Announcements
New Ranks and Rank Icons in 2020

New Ranks and Rank Icons in 2020

Read the announcement for more information!

New Kudos Given Badges Coming

New Kudos Given Badges Coming

We're rolling out new Kudos Given badges. Find out how many Kudos you've given.

November 2019 Community Highlights

November 2019 Community Highlights

Get an overview of the events and great community content from November.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)