Changing font colour of my measure based on matrix Hierarchy

[rodri2196]

Hi All,

I am using a matrix visual in which I have populated different columns and measures to display data.
The problem I am struggling is, For each level of my matrix hierarchy, I want to display a different FONT COLOR.  Can this be achieved by Conditional Formatting?

At this level It calculates properly.

When drilling down to deeper levels in the hierarchy, I want to maintain the visibility of subtotal values while hiding the detailed data, such as values for Weekly Print Cost and Weekly Pay.

Is there a way that this can be achieved? I thought of formatting by Text colour to match the background colour but that did not seem to work on a hierarchy.

Any sort of help on this problem will be appreciated.

Thanks 🙂

[Ritaf1983 · Accepted solution]

Hi @rodri2196 
Unfortunately, we don't have the desired functionality you can suggest an idea here :

https://ideas.fabric.microsoft.com/ideas/search-ideas/?q=different%20colors%20matrix&page=1

There is some workaround for measures using isinscope function, check if this can help.

There is an example in the linked discussion :

https://community.fabric.microsoft.com/t5/Desktop/Use-different-colors-for-different-row-levels-in-a...

(the response of @v-frfei-msft)

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly