Forum Discussion
Sorting Dimension
Basing on the aging bucket, they should be sorted correctly following the order below without using a custom sort unless you have other buckets not in the list.
| 0-7 Days |
| 10-15 Days |
| 15-30 Days |
| Above 30 Days |
If that is the case, add another table that contains the bucket and the sort order, you can import it or used Power BI's enter data. Create a relationship from that to your fact table, and use the column from that table in your visuals
created relation between sorting table and fact table and tried same way which you have suggested but nos solution refer above graph i want 16-30 Days should be on second number.
Unless Sorting order will availalbe in how this is possbile visual to sort
Based on your picture, the data type of your sort order column is text, you need to change the data type to whole number.
Then refer to the steps danextian offered, it should can work.
If the solutions danextian and i offered help you solve the problem, you can considet to accept them as solutions so that more user can refer to.
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
