set background color for one of the hierarchy in a matrix

[nj17]

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.

Thanks,

Nj

[speedramps]

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]

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]

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

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 ! 

[nj17]

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?