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 n...
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.

     

KNP's avatar
KNP
Icon for Super User rankSuper User
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.