Colours and Line and Stacked Column Chart

[SachinC]

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

[Greg_Deckler]

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

[SachinC]

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

Thanks.

[v-shex-msft · Accepted solution]

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