Sorting Months

[sdhn]

Hello All,

I created a report based on the following time period. I am comparing two time periods as below:

April 2019 to March 2020  

Please note: Values of Jan , Feb & March is from 2020.

Jan	Feb	March	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec

April 2020 to Now

Please note: Values of Jan , Feb & March is from 2021.  

Jan	Feb	March	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec

Please note:

Values in the month of Jan Feb & March is from lastest year.  April to Dec is from Previous year.

I want to display matrix as below:

April 2019 to March 2020

Please note: Values of Jan , Feb & March is from 2020.

Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec	Jan	Feb	March

April 2020 to Now

Please note: Values of Jan , Feb & March is from 2021. 

Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec	Jan	Feb	March

Your help will be apprciated. 

SD

[Anonymous · Accepted solution]

HI @sdhn,

I'd like to suggest you create a custom sorting order table and link to raw table fields and use new table fields on your chart to achieve custom sort order.

Custom Sorting in Power BI 

Regards,

Xiaoxin Sheng