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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
nj17
Helper III
Helper III

set background color for one of the hierarchy in a matrix

Hi,

I have a matrix and i want to show the background color of one of the hierarchy level in grey color.How I can achieve this?

I want to show grey background only for below 3rd level of hierarchy.How can I achieve this.

nj17_1-1662199792072.png

 

Thanks,

Nj

 

 

4 REPLIES 4
speedramps
Super User
Super User

Hi nj17

 

I do not work for Microsoft, I just volunteer to help answer questions.

Sorry - the standard matrix visual does not allow row conditional formating.

You could consider searching for a customer visual that does.

 

Please click the Accept as Solution button and thumbs up button.

I have answered your question correctly, albeit it might not be the answer you wanted.

 

 

 

 

speedramps
Super User
Super User

Thanks nj17  for the thumbs up. Please can you click the "accept the solution" button

You can see from the example I provded that the solution works.
If you need to change the scope of your question then please accept this soution and raise a new ticket.

 You will get a quicker response and each volunteer solver will get the kudos they deserve. Thank you ! 

😀

speedramps
Super User
Super User

Click here to download the solution 

 

How it works ....


The DAX measure is set to Grey if the visual cell is at level 3.
If there is level 4 or 5 then you need to set that to blank, because they are filtered within the 3 hierachy   

 

Level RAG =
SWITCH(TRUE(),
ISFILTERED(Sales[Level4]), BLANK(),
ISFILTERED(Sales[Level3]), "Grey")
 
then in conditonal fomating set the
format style = Field valeu
Based on field = Level RAG
apply to= Valeus and totals
 
speedramps_0-1662206103904.png

 

Thanks for reaching out for help.

I put in a lot of effort to help you, now please quickly help me by giving kudos.

Remeber we are unpaid volunteers and here to coach you with Power BI and DAX skills and techniques, not do the users job for them. So please click the thumbs up and accept as solution button. 

If you give someone a fish then you only give them one meal, but if you teach them how to fish then they can feed themselves and teach others for a lifetime.  I prefer to teach members on this forum techniques rather give full solutions and do their job. You can then adapt the technique for your solution, learn some DAX skills for next time and soon become a Power BI Super User like me. 

One question per ticket please. If you need to extend your request then please raise a new ticket.

You will get a quicker response and each volunteer solver will get the kudos they deserve. Thank you ! 

 

Hi @speedramps 

Thank you for the help but one question I have is that Do I need to set conditional formating for all columns I have in matrix as you set only for Amount?

other thing is I wanted the whole row in grey color like below .is it possible?

nj17_0-1662210773959.png

 

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors