How to avoid showing Zero value sin bar chart

[Snagalapur]

Hi All,

Could you please share how to avoid showing Zero revenue/values in bar chart. 

I have conditional colour format for bar in view.

Thank you.

[v-zhouwen-msft]

Hi Jai-Rathinavel ,thanks for the quick reply, I'll add more.

Hi @Snagalapur,

Check if you have selected this option. Uncheck it, as Power BI will automatically hide null values by default when using quick measure.

Best Regards,
Wenbin Zhou

[Jai-Rathinavel]

@Snagalapur Click the visual, then the check the right side to see the filters. Now locate the aggregated field and apply filter.

Example: sum(table[revenue]) is not 0 

Thanks,

Jai

[Snagalapur]

could you please provide example, I couldnt  resolve issue.

[Jai-Rathinavel · Accepted solution]

@Snagalapur, In your case make Sum of Q3-24 ACT as not 0 like below

Did I answer your question? If yes, please mark my post as a solution.

Thanks,

Jai

[Snagalapur]

Thank you so much for help.