Issues sorting quarters and year

[Anonymous]

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 :

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 error

DateTable

Thank you in advance! 🙂

[judspud · Accepted solution]

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]

This solved my problem! Thank you @judspud !