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
elbartje
Frequent Visitor

Reorder Axis

I got this graph:

elbartje_0-1640593517044.png

It shows me all data of 2019,2020 en then for 2021 I see the data for each month.
I want the data in this order in my X-Axis:
2019, 2020, 2021, Jan, Feb, Mar, Apr, May, June, July, Aug,Sept, Oct, Nov, Dec
If I change my month format to 1,2,3 then my graph looks like this:

elbartje_1-1640593691719.png

 

Can I sort on a column that is not in the visual, or can I add a dummy column to sort on in the graph ?

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@elbartje , You need to create a sort order column and mark that sort column

 

Example

Axis column 1 = [Axis Column]

 

Axis column sort =  Switch(true(),

[Axis Column] = "2019", 1,

[Axis Column] = "2010", 2,

//Add others )

 

Mark Axis column sort as sort column for Axis column 1 and use Axis column 1 in visual

 

Sort Month.png

 

How to Create Sort Column and Solve Related Errors:
https://www.youtube.com/watch?v=KK1zu4MBb-c

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

View solution in original post

2 REPLIES 2
elbartje
Frequent Visitor

Thank you that did the trick !!

amitchandak
Super User
Super User

@elbartje , You need to create a sort order column and mark that sort column

 

Example

Axis column 1 = [Axis Column]

 

Axis column sort =  Switch(true(),

[Axis Column] = "2019", 1,

[Axis Column] = "2010", 2,

//Add others )

 

Mark Axis column sort as sort column for Axis column 1 and use Axis column 1 in visual

 

Sort Month.png

 

How to Create Sort Column and Solve Related Errors:
https://www.youtube.com/watch?v=KK1zu4MBb-c

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

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.