Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Conditional formatting for Total Labels

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?

 

 

 

Need Help

4 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    HI Anonymous,

    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

  • M181ut's avatar
    M181ut
    New Member
    2 years ago

    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.