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.