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 c...
Need Help
Tips and Tricks
Tutorial Requests
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

    • Tasos's avatar
      Tasos
      Helper II
      7 years ago

      Hello Anonymous,

       

      I hope that this link will help you.

       

      Thank for your time!

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        Hi Tasos,

         

        Thanks for Sharing the Pbix File.

         

        I have a concern that if you have data like combination of number and some text like (412079-NEW) then how you actually want in your visual. 

        As dedelman_clng discussed that it is only valid for Number and Date type data because they can be grouped. like

        if i have data 1 to 10 then in categorical ways i can show 1,2,3,4,5,6,7,8,9,10 and in continous way like 1....5...10.

         

        So if you have text then i have to group or set ranges for your data then might be possiblity to do that. So Again Could you please look into this and clarify my concern. :smileyhappy:.

        Because i dont have any idea about your actual data and what exact output you want.

         

        Best Regards,

        Ravi