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
Highlighted
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
Highlighted
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

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 Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (3,983)