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
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

       

      • Tasos's avatar
        Tasos
        Helper II
        7 years ago

        Hello Anonymous,

         

        What I really need is a percentage as an X-Axis instead of the actual value (see example https://www.dropbox.com/s/yaj04exg04yu2bm/pareto%20example.xlsx?dl=0).

         

         

        I can create a column having this value, however, by doing that I will lose the option of creating a dynamic output when slicers are applied. What could work though is to create a measure instead. However, as we cannot have measures as X-Axis, I assume that what I want is not feasible (at least at the moment).

         

        I hope that what I am looking for is clearer now.

         

        Thanks for your time!!

         

        Tasos