Forum Discussion
Matrix Row Hierarchial Layers Format Options
I want to show a matrix with three different hierarchial layers. Each layer should have a different format for clarity reasons. Like this: Is this possible? As the per row-level for subtotal...
Hi PhilippeG
You can only use conditional formatting for the currently expanded hierarchy.
For more information, you can refer to the following posts:
Solved: Conditional Formatting - Microsoft Fabric Community
Multiple level hierarchy matrix colors - Microsoft Fabric Community
Or you can use the following measure:
Measure =
SWITCH(TRUE(),
ISINSCOPE('Table'[RowA]),"black",
ISINSCOPE('Table'[RowB]),"blue",
ISINSCOPE('Table'[RowC]),"red")
You can then click on the icon below to enter the individual matrix levels:
Best Regards,
Jayleny
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.