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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Issues sorting quarters and year

Hi Everyone,

 

I hope you can help me with my problem. I'm creating a visual wherein the X- AXIS should be sorted like this :

 

Opport.png

 

Q1 2018 | Q2 2018 | Q3 2018 | Q4 2018 | Q1 2019 | Q2 2019 | Q3 2019 and so on

 

but whats happening is

 

Q1 2018 | Q1 2019 | Q2 2018 | Q2 2019 | Q3 2018 | Q3 2019 and so on

 

I have a date table and I sort by column the QUARTER column by MONTHYEAR(integer) but it causing an errorSortERror.png

 

DateTable

datetable.png

 

Thank you in advance! 🙂

 

1 ACCEPTED SOLUTION
judspud
Solution Supplier
Solution Supplier

Hi @Anonymous 

 

Try creating a column that is numerical as the year followed by the quarter

 

for example 2017 Q1 = 20171, 2017 Q2 = 20172....

 

One method could be 'QuarterOrder = [Year]*10 + [QuarterOfYear]'

 

You can then sort the Quarter column by the QuarterOrder column to create the correct order

 

Hope this helps

 

Thanks,

George

View solution in original post

2 REPLIES 2
judspud
Solution Supplier
Solution Supplier

Hi @Anonymous 

 

Try creating a column that is numerical as the year followed by the quarter

 

for example 2017 Q1 = 20171, 2017 Q2 = 20172....

 

One method could be 'QuarterOrder = [Year]*10 + [QuarterOfYear]'

 

You can then sort the Quarter column by the QuarterOrder column to create the correct order

 

Hope this helps

 

Thanks,

George

Anonymous
Not applicable

This solved my problem! Thank you @judspud !

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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