Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
sdhn
Responsive Resident
Responsive Resident

Sorting Months

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

 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

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

View solution in original post

1 REPLY 1
Anonymous
Not applicable

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

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.