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