Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
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