Remove/Exclude zero-values bar chart

[Anonymous]

Hi,

I have a bar-chart where I want the bar-chart not to show zero-values like it does here:

Instead I want it to display it like this:

Any ideas on how to do this?

Both variables used are whole numbers.

Thanks!

[amitchandak]

@Anonymous , the first one seems like, a visual with legend and second one without it. If you using legends, I doubt you can reduce the space.

In case you are not using create measure like

New Measure = if([measure]=0, blank(),[Measure])

[Anonymous]

I am not using a legend. I have two variables which both are a whole numbers.

When I do the calculation you recommend I need to use sum(measure) and when I do this I cannot add the new measure to the axis.

Maybe it's just not possible then?

[v-lili6-msft]

hi  @Anonymous 

Do you mean you put a measure into axis? Which bar chart do you use in this report?

Please share your sample pbix file for us to have a test. that will be a great help.

Regards,

Lin