Forum Discussion
Pareto Chart Order X Axis
Case Closed 🙂
Maybe it's not meant to be entirely a Pareto chart, but I do care that the line on the chart starts according to payment terms. Ultimately I would like it to be ranked as below is there an option to adjust the chart for that result??
In that case I will know that for example 80% of all cases are due in next 60 days.
Hi, Anonymous
You mean, you want to sort the X-Axis like the picture?
Please correct me if I am wrong.
In this case, you have to create an Index-number-column for the Paymentterm-category to set up the sort-order.
You can easily create the index number column in PowerQuery Editor.
I hope it helped.
Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
HI Jihwan_Kim
I have for each payment term the index column:So each row has the index number for a payment term. All I want to do is a cumulative measure not from the biggest one but from the first one...
Hi, Anonymous
It is quite hard for me to create sample data or a sample pbix file, because you also have other tables and columns related to this calculation.
However, when I saw your calculated measure that was shown in your initial question, the calculation is using "greater than or equal to AMOUNT SUM".
Instead, change it to "less than or equal to ORDER ID of Paymenttem".
I hope it helps.
Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Hi, Anonymous
I just saw that you added the blue line in the picture.
Does the blue line mean accumulate the total amount of paymentterm-category?
If so, you can create a measure that describes the cumulative total.
If you can share the sample pbix file or the sample data, I can try to create it.
Thank you.
