Forum Discussion
Can't control x-axis intervals?
Hi PBI community,
I can't seem to manipualte the x-axis intervals on my column chart visualization. My data is non-date data (it's just a simple count), but the X axis section of the formatting pane is throwing me the option to choose either continuous or categorical. When it's on continous, I see the columns represented the way I want them, but the x-axis labels are stuck at 2-digit intervals (2,4,6, etc.) When I change it to categorical, I see all the appropriate x-axis labels, but am not able to see the entire range I want to see (i.e. I only see x-axis labels for where data exists, as opposed to seeing the whole range represented).
Any help is appreciated :)
I think I was able to find a work around by changing the x-axis type to Categorical, then sorting by #Quotes, ascending in the visualization. I can't help but feel like my queries behind the scenes are poorly structured, but this seems to be working. Thank you for your help!
10 Replies
Hi askjervenboyd ,
On the Axis option go to the column and select show items with no data:
Regards,
MFelix
Hi MFelix ,
Thanks for the quick response. It doesn't fix my issue, which is that I'm not seeing labels for items that DO have data. It's so weird!
Best,ASB
Hi askjervenboyd ,
Check the size of the font for the axis and/or increase the size of the chart to see if the numbers appear.
Regards,
MFelix
