My bar chart isn't showing all data values in the x-axis. My database shows all these rows but it's not being displayed. For context, the first column is supposed to be the x-axis in the bar chart.
y
Perhaps try sort ascending on the axis column, so the 6, 4, 8... are in numerical order.
Edit: Tested it, and it doesn't matter
You've tagged this as Perspective and Ignition 7.9.
Perspective was introduced in 8.0. It looks more like Vision. Can you fix the tags in your question?
Throwing your dataset into a bar chart produced this result:
Which seems to be what you would expect, so I guess we need some details about your set up. I'm curious about the datatypes your query is returning. The left alignment indicates string when the columns should probably be type integer and float.