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.

     

4 Replies

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

     

  • Pragati11's avatar
    Pragati11
    Icon for Super User rankSuper User
    10 months ago

    HI EstherBR 

    You can apply background color or text color to Row Totals :

    In the same way Column Headers can only be given background colors or text colors:

    The reason for this is conditional formatting is driven by some rules which can only be applied to a value that's being shown against columns.

    Hope this helps.