Aligning the data by financial month order

[uc]

Hello

I have got a visual in Power BI  desktop which displays data for 2021/22. I use Dimdate workflow. When I loaded January 2022 data, it gets displayed at the left (as shown in the picture below) while I wanted to know whether it can be displayed (after Dec 2021 data) on the right? Any advise is much appreciated. Thanks

[v-yalanwu-msft · Accepted solution]

Hi, @uc ;

You could create a month Column. then sort by date column.

1.create a column.

month = FORMAT([Date],"mmmm")

2. then sort by date column.

The final output is shown below:

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[uc]

Thanks a lot. It works!

[Greg_Deckler]

@uc So normally you would have a fiscal year month column that you would use for sorting. So something like 202101, 202102, 202203, etc. You then use the Sort By column setting.