Forum Discussion
Rearranging months by FY Apr-Mar
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
Memorable Memberhi 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