Conditional formatting for Total Labels

[Gerri]

Hello, 

I'm using a measure to color the total label but for some reason it's not working for the stacked coloumn chart.

I know that my measure is working fine from the tables but for some reason it's not working for total labels.

Where am I going wrong?

[M181ut]

For other people who had a similar problem, I found a way to solve it.

I have a stacked graph of charges divided by categories and for an unknwon and bizarre reason the formatting of total labels is based on the top column of the stacked column so only one category and not the total.

To bypass this, I created a measure CALCULATE([charges], ALLEXCEPT( list of filters I need BUT categories)) and I base my formatting on this new measure that is not affected by categories.

[v-shex-msft]

HI @Gerri,

When you use table and matrix visuals, conditional formatting works on the detail levels and they did not apply to the total level.
For the stacked column chart, the conditional color formatting only worked when you do not use table columns on the legend fields.

Regards,

Xiaoxin Sheng

[amitchandak]

@Gerri , the Color on the label is based on grand total value. That is the reason

[Gerri]

How should I edit the measure to split it over the months?