Forum Discussion
Matrix conditional formatting for column total only
Hi,
For matrix conditional formatting, can we choose to which Total it will apply ? the options now is Total only but no selection to which total. Is there a trick to do so ?
Because I have format like this :
This it self already bugging me since I don't want the Row total to be coloured (formatted) also, only the Column total on the rightmost.
Then if we expand the month, it will become more 'ugly' ->
Else can I have some advice to make this report more attractive but not hurting my eyes.. 😅
Thanks,
you should be able to use something like
Blue Formatting = IF ( ISINSCOPE ( Calendar[Quarter] ), BLANK(), "#B0D0E2" )which should leave all columns but the row totals (on the far right, those are row totals) blank. You will need to update the table and field names to match your model.
1 Reply
- jdbuchanan71Super User
you should be able to use something like
Blue Formatting = IF ( ISINSCOPE ( Calendar[Quarter] ), BLANK(), "#B0D0E2" )which should leave all columns but the row totals (on the far right, those are row totals) blank. You will need to update the table and field names to match your model.