Power BI chart bar reorder

[Sudbrl]

Dear All

I am creating a simple bar chart in Power BI but unable to reorder the position of bar manually. The FY column is Bikram Sambat fiscal year. Can anyone suggest how i can re-order the bar? For example position Q1 2077/78 bar in first which is currently in second last.

[v-stephen-msft]

Hi @Sudbrl ,

You can create a new table contains a FY column and  a custom order column, and then create a relationship with the original table. Finally use the "sort by column" feature.

Reference:

Solved: Custom Sorting in PowerBI? - Microsoft Fabric Community

Sort a Column with a Custom Order in Power BI - RADACAD

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.           

[Ritaf1983]

Hi @Sudbrl 
You should use a date table with a column that will sort your quarters in the needed order.

For more information please refer to the linked tutorials :

https://www.youtube.com/watch?v=ef-KmCB-qXY

https://www.youtube.com/watch?v=1-agbCF7HwY

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.