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

10 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi Mariusz 

      Problem is not with the edit interactions , I dont want to show any bar to the zero values in the chart.

      Thank You

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Anonymous , Mariusz 

     

    I also have the same issue. Did you find any solution?

     

     

    • 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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi,

     

    can you use this formula?

    Measure 4 = IF(CALCULATE(SUM(Sayfa1[Column2]))=0;1;0)