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

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

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hi Tasos,

       

      I have gone through your file. I understand data and i think it is possible to implement column will be dynamic also. I have implented by taking your sample data of columns (i.e: Product,Rank and Sales). If you have rank column then it is very easy to do.

       

      I am attaching pbix file of my solution.

      https://drive.google.com/file/d/1X34vLe5rzn5vSPNH21-nzKTncFMH6Kox/view?usp=sharing

       

      Hoping that i understood your requirement. :smileyhappy:

       

      Regrads,

      Ravi

      • Tasos's avatar
        Tasos
        Helper II
        7 years ago

        Hi Anonymous,

         

        You have clearly understood my requirement and I appreciate your effort. 

         

        However, there is an issue with your solution. The ranking is predefined and static. This means that if I apply filters (e.g. time period/country of sales/different type of products, e.t.c) the ranking will not be the same as the "total" one. 

         

        If you can solve this, then you have fully solved my problem.

         

        Thanks,

        Tasos