Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 🙂
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 :
(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
User | Count |
---|---|
99 | |
87 | |
80 | |
76 | |
71 |
User | Count |
---|---|
112 | |
105 | |
96 | |
74 | |
66 |