How do I prevent x-axis labels on Reporting charts being forced to certain data types.
As you can see in my sample, the data table shows that the x-axis should be text, but the chart has forced the x-axis to be numeric and where it can't parse the value as a number it shows it as 0.
How can I make it show as text, like in the data table on the left?