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
Super User
7 years ago

Hi askjervenboyd ,

 

On the Axis option go to the column and select show items with no data:

 

 

Regards,

MFelix

  • askjervenboyd's avatar
    askjervenboyd
    Frequent Visitor
    7 years ago

    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

    • MFelix's avatar
      MFelix
      Super User
      7 years ago

      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

      • askjervenboyd's avatar
        askjervenboyd
        Frequent Visitor
        7 years ago

        Hi MFelix ,

         

        Thanks for the suggestion. Font size is lowest at 8pt, resizing does nothing. Show items with no data is checked under the Axis field in visualizations. The data type is whole number, as well as the format. What a mystery. 


        Best,

        ASB