Always show the same x-axis values in the same order.

[aortuno]

I'm putting together a dashboard that has two bar charts, they each display different measures for the same items.

Item A, Item 2 and Item 3.

Some days I refresh the data and whichever Item has a value of zero disappears from the X axis.

What I want is for the bar chart to always show the same values in the x-axis in the same order, even if sometimes some of them are zero and display no bar. 

Is that possible? 

Thanks!

[RMDNA · Accepted solution]

@aortuno,

In the field options on your chart, select your axis and check "Show items with no data." That should give you what you need.

[aortuno]

Thanks that did it.