Remove Multiple Zero Bars from Stacked Column Chart

[Anonymous]

Hi All , 

Suggsets some way to to remove multiple $0 level bars , to show $0 value on  the Y- Axis. 

Thank You  

[amitchandak]

In visual level filter, you should able filter measure value >0

[Osmanakgunduz]

Hi,

can you use this formula?

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

[Anonymous]

Hi @Anonymous , @Mariusz 

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

[Mariusz]

Hi @Anonymous , @Anonymous 

Can you describe your problems in more detail?

Best Regards,
Mariusz

Please feel free to connect with me.

[Anonymous]

@Mariusz @Anonymous @amitchandak @Osmanakgunduz 

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]

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

[Anonymous]

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]

Hello @Anonymous 

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

[Mariusz]

Hi @Anonymous 

Try Edit interactivity.

https://docs.microsoft.com/en-us/power-bi/service-reports-visual-interactions

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.

[Anonymous]

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