Forum Discussion

EstherBR's avatar
EstherBR
Icon for Helper III rankHelper III
10 months ago
Solved

Format only the row subtotals

Hi,

 

I have the following matrix:

Is there any way to apply conditional formatting to only the row subtotals? If this is not possible, it is possible to apply conditional formating to the name of the month? 

 

Thanks!

Need Help
  • KNP's avatar
    KNP
    10 months ago

    Hi EstherBR,

     

    It may not be exactly what you're after, but this may work.

     

     

    • Create a new measure (change to suit).
    _colour = 
    IF(
        NOT ISINSCOPE(FactInternetSales[ProductKey])
        , "light blue"
    )​

     

    • Select your visual.
    • In the formatting options, choose cell elements > Series > Background color
    • Select Field value > Values and Totals > your measure
    • Click OK.
    • Repeat for other columns.