Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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! 🙂
Solved! Go to 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
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
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |