Extra Bar Appearing in Stacked Column Chart

[Anonymous]

Hi,

I am trying to plot a chart with a column that only has 2 unique values but when I use it a stacked column or row chart, I get a 3rd bar appearing that has no values appearing.  The values are 0 and 1, but 0,1,1 appear when I plot it with nothing appearing in the middle 1. Data type is numeric so issue shouldnt be spaces around 1 throwing it off.

Does anyone know how to remedy this? I click on the dropdown in my data for that column and there are only 2 distinct values.

Thanks in advance,

Vizwiz 

[v-lili6-msft]

HI, @Anonymous 

I have test on my side, it works well.

Could you share your sample pbix file or some sample data with some screenshots?

There may be something wrong in other.

Best Regards,

Lin

[Anonymous]

solution was to chage data type from number to text..

but as stated there were only 2 possible values for the numbers, 0 and 1..

thanks!