Forum Discussion

admin_xlsior's avatar
admin_xlsior
Post Prodigy
5 years ago
Solved

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,

 

 

 

 

  • admin_xlsior 

    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

  • admin_xlsior 

    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.