Forum Discussion
munchkin666
Helper II
Helper IISort months previous year against current year
Hi. I am trying to create a bar chart dashboard, which would compare previous months year against the current one. So I would like to see: Jan2019 Jan2020 Feb2019 Feb2020 etc. What is the e...
hi munchkin666
For your case, you could use sort by column in power bi to get it.
https://radacad.com/sort-by-column-in-power-bi
Then just create a order column as this:
Order = MONTH([Date])*10000+YEAR([Date])Then selected YearMonth column, click ->sort by columns->Order
and here is sample pbix file, please try it.
Regards,
Lin
amitchandak
Super User
Super UserCreate a sort column like
Month Sort = format([Date],"MMYYYY")
And use that sort column for Month Year column you have as of now
https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column