Forum Discussion

SachinC's avatar
SachinC
Helper V
8 years ago
Solved

Colours and Line and Stacked Column Chart

Hi,

I have a chart which looks great, however for a line value of zero, how can I use a different colour please?  I want to report on line values of zero to be of colour red or similar. Please help?

Regards,

S

Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    Hi SachinC,

     

    Since zero value cannot direct shows with sum mode on chart, you should use other summary mode to deal with it.

     

    Sample: add a custom column to add tag, then write a measure to count the zero count.

     

    Calculate column:

    Category = IF([Amount]=0,"Zero","Normal")

    Measure:

    Zeo Count = CALCULATE(COUNT(DateTable[Category]),DateTable[Category]="Zero")

     

    Regards,

    Xiaoxin Sheng

3 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    8 years ago

    You might have to segment those values off into a separate category.

    • SachinC's avatar
      SachinC
      Helper V
      8 years ago

      Can you elaborate on your thinking please? I will then have a go...

      Thanks.

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        Hi SachinC,

         

        Since zero value cannot direct shows with sum mode on chart, you should use other summary mode to deal with it.

         

        Sample: add a custom column to add tag, then write a measure to count the zero count.

         

        Calculate column:

        Category = IF([Amount]=0,"Zero","Normal")

        Measure:

        Zeo Count = CALCULATE(COUNT(DateTable[Category]),DateTable[Category]="Zero")

         

        Regards,

        Xiaoxin Sheng