Forum Discussion

Tasos's avatar
Tasos
Helper II
7 years ago

Continuous x-axis issue

Hello,

 

I am trying to change the categorical type X-Axis into a continuous one but with no success.

 

I have created a Pareto Chart with the cumulative quantity per product, however, I cannot change the X-axis so it can fit all the products without scrolling.

 

 

Any Ideas on that?

 

 

Thanks

 

Need Help
Tips and Tricks
Tutorial Requests

13 Replies

  • dedelman_clng's avatar
    dedelman_clng
    Community Champion
    7 years ago

    Check the datatype of your X-axis variable.  Only numbers and dates can be continuous.

     

    Hope this helps

    David

    • Tasos's avatar
      Tasos
      Helper II
      7 years ago

      Thanks for the reply. However, it doesn't really help me on how to solve it. 

       

      The product name is a combination of numbers and letters and therefore I cannot change the datatype into a number. 

       

      Still, thanks for the info.

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        Hi Tasos,

         

        Could you please share your pbix file or sample data?

         

        Best Regards,

        Ravi

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Hi. My x-axis are numeric, but I still could not convert Categorical to Continuous . Please advise