Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Remove Multiple Zero Bars from Stacked Column Chart

Hi All ,  Suggsets some way to to remove multiple $0 level bars , to show $0 value on  the Y- Axis.  Thank You  
Need Help
Mariusz's avatar
Mariusz
Community Champion
6 years ago

Hi Anonymous , Anonymous 

 

Can you describe your problems in more detail?

 

Best Regards,
Mariusz

Please feel free to connect with me.
Mariusz Repczynski

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Mariusz Anonymous amitchandak Anonymous 

 

Hi,

If you look at the Y-Axis, it shows zero two times (one in the bottom and one in the centre).

I am calculating a measure which return me a value. I want to show all the date but the bar should not be there as the measure value is zero. It's very misleading if you just look at the chart(bars are going up and down) but ultimately it's value is zero. 
As you can see in the table visual this measure is returning zero.
Can you please help me. It's very urgent.

 

Thanks in advance. Any help is appreciated.

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

    Can you  share y-Axis properties Start, End, Display Unit, Value Decimal Place

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi amitchandak 

       

      Y- Axis properties are set to auto. I ran into another issue. As you can see in img2 on Y-Axis, there are 3 0M and 3 1M dotted lines. I don't know why it's happening.

      img2

      • jdbuchanan71's avatar
        jdbuchanan71
        Super User
        6 years ago

        Hello Anonymous 

        Try changing the Y axis display units to "None" or adjust the number of decimal places you are showing.