Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
sahmed1
Advocate I
Advocate I

Custom Sorting

‎03-10-2017 03:02 PM

Hello,

 

I cannot seem to sort my quarters to chronologically order.

 

 

Please help me!

 

Shaila 

Labels:
Message 1 of 4
1,095 Views
0
1 ACCEPTED SOLUTION
Vvelarde
Community Champion
Community Champion
In response to sahmed1

‎03-10-2017 03:30 PM

@sahmed1

 

You need a extra column with the order

Quarter  Order

2016Q1  1

2016Q2  2

2016Q3  3

2016Q4  4 

...

...

 

After that use Sort By Column  -- (in modeling menu)

 




Lima - Peru

View solution in original post

Message 4 of 4
1,473 Views
0
3 REPLIES 3
Vvelarde
Community Champion
Community Champion

‎03-10-2017 03:10 PM

@sahmed1

 

What is the order?

 

Maybe this Thread can help you

 

https://community.powerbi.com/t5/Desktop/Sorting-Data-Manually/m-p/140138#M60320




Lima - Peru
Message 2 of 4
1,089 Views
0
sahmed1
Advocate I
Advocate I
In response to Vvelarde

‎03-10-2017 03:13 PM

the order is:

2017 q1 ; 2016 q4 ; 2016q3 ; 2016 q2

 

i need it to go

2016 q2 ; 2016 q3; 2016 q4; 2017 q1

Message 3 of 4
1,086 Views
0
Vvelarde
Community Champion
Community Champion
In response to sahmed1

‎03-10-2017 03:30 PM

@sahmed1

 

You need a extra column with the order

Quarter  Order

2016Q1  1

2016Q2  2

2016Q3  3

2016Q4  4 

...

...

 

After that use Sort By Column  -- (in modeling menu)

 




Lima - Peru
Message 4 of 4
1,474 Views
0

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

September Power BI Update Carousel

Power BI Monthly Update - September 2025

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

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

View All
Top Solution Authors
View All
Top Kudoed Authors
View All