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

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