Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Remove/Exclude zero-values bar chart

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 va...
Need Help
amitchandak's avatar
amitchandak
Super User
5 years ago

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's avatar
    Anonymous
    Not applicable
    5 years ago

    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's avatar
      v-lili6-msft
      Community Support
      5 years ago

      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