In bars chart display all numeric categories in x-axis without creating a new dataset
We have a dataset with a numeric category that ranges from 1 to 10, and we’re trying to build a bars chart with that category on the x-axis and a count of elements in the y-axis. Sometimes not all of the categories have values to display. Is there a way to maintain all numbers shown in the axis even if the count of their elements is zero (without having to create a new dataset or modify the one that we’re using)?
We have a workaround for this by creating a new dataset that left joins numbers from 1 to 10 with the original, but it just seems too much overhead.
Any advice would be appreciated.