Format only the row subtotals

[EstherBR]

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!

[KNP · Accepted solution]

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]

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.

[EstherBR]

hi @Pragati11 , I understand that conditional formatting cannot be tapply to only the row subtotals or month columns. Is this correct?

[Pragati11]

Hi @EstherBR 

conditional formatting can only be applied to Values when it comes to table or matrix chart in Power BI.

You can check the official documentation here:

https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-conditional-table-formatting