Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
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