Forum Discussion
Rearranging months by FY Apr-Mar
Hi, I have a report that was previously set up by another user but unfortunately the months were set up to reflect Financial Year. Now that the time has come to do my January reports it is putting that at the beginning of my table instead of at the end after December. I've tried looking online at all of the help topics but I must admit, Power Bi is very new to me. I see that we can't just click sort on the modelling tab that I need to add another table to my data. Is anybody able to give me instructions that even I could follow. Many thanks.
hi MrsHanchett ,
you need to create a column with the custom sort order you want. You could either do this using DAX or Power Query Editor.
Ideally this is done on the date/calendar table.
In power query editor,
create a conditional column, reference the [Month Column] in the value type in the Month Name, In the output, the wat you'd like sort it by example (April , 1 , May , 2 etc.)
Click ok once done. Close and Apply.
In the data view, go the the table.
select the [Month] Column , use " Sort by" and select the column created with the custom order.
refer to (12) Sort a Column with a Custom Order in Power BI - YouTube
incase it is already sorted by a custom column, customize the existing column
1 Reply
- adudani
Memorable Member
hi MrsHanchett ,
you need to create a column with the custom sort order you want. You could either do this using DAX or Power Query Editor.
Ideally this is done on the date/calendar table.
In power query editor,
create a conditional column, reference the [Month Column] in the value type in the Month Name, In the output, the wat you'd like sort it by example (April , 1 , May , 2 etc.)
Click ok once done. Close and Apply.
In the data view, go the the table.
select the [Month] Column , use " Sort by" and select the column created with the custom order.
refer to (12) Sort a Column with a Custom Order in Power BI - YouTube
incase it is already sorted by a custom column, customize the existing column