Remove blank or 0 observations in clustered column chart

[Anonymous]

Hi,

This is probably a stupid question i have a clustered column chart where I'm showing the last 7 days and number of observations of different categories. Some values are blank (no observation) and it shows on those days.
Is there an easy way to remove these?

Thanks!

[amitchandak]

@Anonymous 

You can remove those by using visual level filter

If removing 0 means remove the gap between the bars that might not happen.

[Anonymous]

I have set my count measure to not include 0 and not include blanks, but it still shows a gap on i.e 21st and 22nd

[v-lionel-msft]

Hi @Anonymous ,

Have you tried this option?

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.