Forum Discussion

askjervenboyd's avatar
askjervenboyd
Frequent Visitor
7 years ago
Solved

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 ...
Need Help
  • askjervenboyd's avatar
    askjervenboyd
    7 years ago

    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! 

MFelix's avatar
MFelix
Icon for Super User rankSuper User
7 years ago

Have you tried to redo your chart from the start?

 

Just taking out hipothesys.

 

As I refered in my testing that did no happen.

 

Regards,

MFelix

askjervenboyd's avatar
askjervenboyd
Frequent Visitor
7 years ago

Hi MFelix ,

 

Still no luck. I recreated the report and the chart straight from the sources and made the visualization as large as I could. 

 

The interesting thing is, if I filter the chart 1-10, each column gets an axis label. If I do anything beyond 10, it shows axis labels only in increments of 2. 

 

Interestingly, when you try to do 1-12, the axis label for 0 also shows up. 

 

I did manage to get it to work by changing from a continuous sort to a categorical sort where it sorts ascending by fiscal month. Very strange! 

 

Best,

ASB

 

1 through 101 through 11Success!1 through 12, with 0 axis label suddenly showing up