Forum Discussion
Snagalapur
Helper IV
Helper IVHow to avoid showing Zero value sin bar chart
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.
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
Jai-Rathinavel
Super User
Super UserSnagalapur 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
SnagalapurHelper IV
Helper IVcould you please provide example, I couldnt resolve issue.
- Jai-Rathinavel
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.