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 have a matrix with two different rows in the Rows level and different values corresponding to each level (used a Switch measure to calculate depending on the row level). I have conditional formatting where I want the colors of the top level in the row hierarchy to be light green if they are greater than 0, light gray if they are 0, or light red if they are less than 0. I do not want to apply this color formatting to the expanded second level in the row hierarchy. I know that there are measures to set up conditional formatting based on field value, but this has not worked for me in just applying this color formatting to the top level values, especially because the values in the matrix switch based on the row level.
Furthermore, when I expand the rows to see the second level values, I do not see the value for my top-level row anymore (only when I collapse back to the top-level do I see the values there). Is there any clean way to show the top-level row hierarchy values also while expanding into the second level?
Solved! Go to Solution.
@vip219 , You can use isinscope for that. When you conditional formatting make sure you use values and total
Switch( True() ,
isinscope(Table[Level2]) , if( [Measure] >0, "Grey", "Red") ,
isinscope(Table[Level1]) , if( [Measure] >0, "Yellow", "Red")
)
You can use that in conditional formatting using field value option
@vip219 , You can use isinscope for that. When you conditional formatting make sure you use values and total
Switch( True() ,
isinscope(Table[Level2]) , if( [Measure] >0, "Grey", "Red") ,
isinscope(Table[Level1]) , if( [Measure] >0, "Yellow", "Red")
)
You can use that in conditional formatting using field value option
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
85 | |
82 | |
65 | |
62 | |
55 |
User | Count |
---|---|
171 | |
111 | |
110 | |
72 | |
71 |