Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Is it possible to have an alternative colour font for the lowest level of a hierarchy? The hierarchy is formed from 3 columns and is located in a matrix. As a report user gets to the bottom of the hierarchy I want the text to show in a different colour that denotes that they have the ability to drill through to an additional report page. This functionality isn't avavaible for the first 2 levels of the hierarchy. From the image below the 2 underlined modules would be coloured coded to #0000EE.
Thanks for your help in advance.
@Anonymous , I doubt Matrix has something like that.
One thing I can think of is a color measure using isinscope . But you can only use it for values only in case of Matrix
Conditional formatting ->fx(advance) -> Field Value -> Select a measure
Switch( True(),
isinscope(Table[Level2]) , "Green",
isinscope(Table[level1]) , "Red"
)
Or you ca use exact value
Switch( True(),
if Table[Level2] = "Computing" , "Green",
isinscope(Table[level1]) , "Red"
)
if needed refer for steps
https://radacad.com/dax-and-conditional-formatting-better-together-find-the-biggest-and-smallest-numbers-in-the-column
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-values
User | Count |
---|---|
93 | |
85 | |
78 | |
68 | |
62 |
User | Count |
---|---|
113 | |
99 | |
96 | |
64 | |
58 |