Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
I have a matrix visual like in the image and it has different hierarchy levels:
I need the matrix to have this background colours for each group. But I need it to continue having thebackground colours even when I open one of the next level groups. And for example if I open the group "VENTAS" (in green) it just shows the colours for the groups that are open in the same level:
In this example, I would still need for the previous level groups to show the colour, for example "APROVISIONAMIENTO" should still be showed in red. But it just shows it if I open that group as well:
The DAX I am using now is:
Solved! Go to Solution.
Hi @antongg7 ,
According to your description, here are my steps you can follow as a solution.
(1) We can create a measure.
Color = SWITCH(TRUE(),
ISINSCOPE('P&G - Jerarquía'[DESCRIPCION]) && MAX('P&G - Jerarquía'[DESCRIPCION])="a","red",
ISINSCOPE('P&G - Jerarquía'[DESCRIPCION]) && MAX('P&G - Jerarquía'[DESCRIPCION])="b","yellow"
)
(2) Then the result is as follows.
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @antongg7 ,
According to your description, here are my steps you can follow as a solution.
(1) We can create a measure.
Color = SWITCH(TRUE(),
ISINSCOPE('P&G - Jerarquía'[DESCRIPCION]) && MAX('P&G - Jerarquía'[DESCRIPCION])="a","red",
ISINSCOPE('P&G - Jerarquía'[DESCRIPCION]) && MAX('P&G - Jerarquía'[DESCRIPCION])="b","yellow"
)
(2) Then the result is as follows.
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
76 | |
74 | |
57 | |
38 | |
33 |
User | Count |
---|---|
71 | |
65 | |
58 | |
50 | |
47 |