Color formatting for matrix with hierarchy levels

Question

I have a matrix visual like in the image and it has different hierarchy levels:&nbsp;&nbsp;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:&nbsp;&nbsp;&nbsp;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:&nbsp;&nbsp;The DAX I am using now is:&nbsp;Color Cuenta de Expotación =VAR _conceptoDesc = SELECTEDVALUE('P&amp;G - Jerarquía'[DESCRIPCION])VAR _conceptoN1 = SELECTEDVALUE('P&amp;G - Jerarquía'[NIVEL 1])VAR _conceptoN2 = SELECTEDVALUE('P&amp;G - Jerarquía'[NIVEL 2])VAR _concepto = IF (ISBLANK(_conceptoDesc),IF(ISBLANK(_conceptoN1),_conceptoN2,_conceptoN1),_conceptoDesc)RETURN&nbsp; &nbsp; SWITCH (&nbsp; &nbsp; &nbsp; &nbsp; TRUE (),&nbsp; &nbsp; &nbsp; &nbsp; _conceptoN1 = "APROVISIONAMIENTO", "rgb(245,138,120)",&nbsp; &nbsp; &nbsp; &nbsp; _conceptoN1 = "PERSONAL", "rgb(255,195,122)",&nbsp; &nbsp; &nbsp; &nbsp; _conceptoN1 = "ALQUILERES", "rgb(255,230,155)",&nbsp; &nbsp; &nbsp; &nbsp; _conceptoN1 = "MANTENIMIENTO", "rgb(255,230,155)",&nbsp; &nbsp; &nbsp; &nbsp; _conceptoN1 = "DIGITAL", "rgb(255,230,155)",&nbsp; &nbsp; &nbsp; &nbsp; _conceptoN1 = "BANCARIO", "rgb(255,230,155)",&nbsp; &nbsp; &nbsp; &nbsp; _conceptoN1 = "TRANSPORTE", "rgb(255,230,155)",&nbsp; &nbsp; &nbsp; &nbsp; _conceptoN1 = "OTROS GTOS.", "rgb(255,230,155)",&nbsp; &nbsp; &nbsp; &nbsp; _conceptoN1 = "MARKETING", "rgb(255,202,202)",&nbsp; &nbsp; &nbsp; &nbsp; _conceptoN1 = "VENTAS", "rgb(198,224,177)",&nbsp; &nbsp; &nbsp; &nbsp; _concepto = "GASTOS", "rgb(245,138,120)",&nbsp; &nbsp; &nbsp; &nbsp; _concepto = "EBITDA", "rgb(158,192,227)",&nbsp; &nbsp; &nbsp; &nbsp; _concepto = "AMORTIZACIONES", "rgb(158,192,227)",&nbsp; &nbsp; &nbsp; &nbsp; _concepto = "BENEFICIO ANTES DE IMPUESTOS", "rgb(158,192,227)"&nbsp; &nbsp; )&nbsp;&nbsp;Is there a way to keep showing the background color for various levels of the hierarchy and not just one of the levels?&nbsp;

anonymous · Accepted Answer

Hi&nbsp;Anonymous&nbsp;,
&nbsp;
According to your description, here are my steps you can follow as a solution.
(1) We can create a measure.&nbsp;
Color = SWITCH(TRUE(),
ISINSCOPE('P&amp;G - Jerarquía'[DESCRIPCION]) &amp;&amp; MAX('P&amp;G - Jerarquía'[DESCRIPCION])="a","red",
ISINSCOPE('P&amp;G - Jerarquía'[DESCRIPCION]) &amp;&amp; MAX('P&amp;G - Jerarquía'[DESCRIPCION])="b","yellow"
)
(2) Then the result is as follows.

&nbsp;
&nbsp;
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.&nbsp;

Forum Discussion

Related content

Matrix formatting

Matrix Row Conditional Formatting

Matrix Visual Hierarchy Level Problem

Formatting Matrix Visuals

Matrix - formatting and Sorting