Forum Discussion
Impactful IndividualBar chart data labels - suppress zeroes
My chart looks like this:
How can I remove zeroes?
Thanks
Hi Markzolotoy ,
1.You could turn off Data labels to not show 0.
2.If you want to keep the data labels, you can write similar measures as follows. Replace the equal value with a null value. And select Show items with no data.
Measure = IF(MAX('Table'[Value])=0,BLANK(),MAX('Table'[Value]))You can check more details from here.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 Replies
Hi Markzolotoy ,
1.You could turn off Data labels to not show 0.
2.If you want to keep the data labels, you can write similar measures as follows. Replace the equal value with a null value. And select Show items with no data.
Measure = IF(MAX('Table'[Value])=0,BLANK(),MAX('Table'[Value]))You can check more details from here.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- mahoneypat
Microsoft Employee
You could make a second measure using the same measure but returns blank if = 0. Then you can add data labels to that new series only.
Regards,
Pat
MarkzolotoyThat will also remove weeks with zero values:
- Ashish_Mathur
Super User
Hi,
Assuming you have dragged a measure to your visual, edit that measure to:
Total sales = if(sum(data[sales])=0,blank(),sum(data[sales]))
Hope this helps.
