Forum Discussion
Sorting Dimension
Hi i have to sort bargraph in descending order . I have a use case where i need to show ageing data Above 30 Days 15_30 Days 10-15 Days 0-7 Days In Power Bi there is no option to set order ...
Hi smishra99acres ,
You can create custom sort in Power BI using a column.
there are so many threads on this forum regarding this. See if the following helps:
https://community.fabric.microsoft.com/t5/Desktop/Custom-Sorting-in-PowerBI/m-p/126534
Also there is a blog about custom sorting in Power BI:
https://radacad.com/sort-a-column-with-a-custom-order-in-power-bi
Hope this helps.
Hi Please find my below use case where i have created a bucket and this i want to show in custom order on bar visuals
Age Bucket = SWITCH(TRUE(),
AND('lead'[Lead Age Calc]>0, 'lead'[Lead Age Calc]<=2), "A - 0-2Days",
AND('lead'[Lead Age Calc]>2, 'lead'[Lead Age Calc]<=7), "B - 3-7Days",
AND('lead'[Lead Age Calc]>7, 'lead'[Lead Age Calc]<=15), "C - 8-15Days",
AND('lead'[Lead Age Calc]>15, 'lead'[Lead Age Calc]<=30), "D- 16-30Days",
'lead'[Lead Age Calc]>30, "E - Above 30Days", "Blank"
)