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 variables used are whole numbers.

 

Thanks!

 

Need Help

3 Replies

  • 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