Forum Discussion
Color formatting for matrix with hierarchy levels
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 thebackgr...
Hi Anonymous ,
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 Anonymous ,
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.