Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
87 | |
85 | |
75 | |
69 | |
65 |
User | Count |
---|---|
214 | |
124 | |
117 | |
82 | |
76 |