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,

 

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    On what logic you are gnerating that i cant understand clearly thtas why i gav you 3 links. Whatever your need you will find in these links.

     

    I will suggest go with 3rd link first.

     

  • Tasos's avatar
    Tasos
    Helper II
    7 years ago

    Hello Anonymous,

     

    Thanks for your time and the links. I do appreciate your help.

     

    However, it still doesn't give an answer to my problem (I guess I wasn't clear).  Please, see below,

     

    The "total ranking" is a column based on total sales. The "ranking" is a measure.

     

    As you can see, when no filters are applied, the two values are the same (as they should)

     

     

     

     

     

     

    However, when filters are applied, then the "total ranking" is no longer accurate.

     

    I am attaching again the PBI file, just in case you still have time to have a look

     

    https://www.dropbox.com/s/31wfabuo26ropa5/pareto%20example.pbix?dl=0

     

    Thanks again