Forum Discussion
Conditional Formatting for specific level of matrix
the idea is that the DAX code you wrote ( the isinscope part ) will always be true on all levels,
because project group is the first level , so all lower levels are inscope of the first level.
modify you code to this :
switch (
true() ,
isinscope( level 2 col of the matrix ) , blank() ,
ISINSCOPE('Sample Table'[Project Group]),
if ( SUM('Sample Table'[Revenue]) > 1000000, "Green", "Red")
)
NB :
you can use if statement .
i prefer switch for readability .
let me know if this works for you .If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🙏
Hi Daniel,
Thanks for your response. When I select Values and Totals, it works well when the matrix is collapsed:
But, it also applies to level 2, which I don't want:
the idea is that the DAX code you wrote ( the isinscope part ) will always be true on all levels,
because project group is the first level , so all lower levels are inscope of the first level.
modify you code to this :
switch (
true() ,
isinscope( level 2 col of the matrix ) , blank() ,
ISINSCOPE('Sample Table'[Project Group]),
if ( SUM('Sample Table'[Revenue]) > 1000000, "Green", "Red")
)
NB :
you can use if statement .
i prefer switch for readability .
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🙏
It works! Thank you so much!