Forum Discussion
Ordering Data by Quarters
Hello - how do I get my report to show the quarters in correct order regardless if the count of some items are higher in other quarters?
I switched my calendar option from Month to Month Year and it is now displaying the months in the correct order.
9 Replies
- Natarajan_MSuper User
Hi jaytrice26 , You need to use the sort by option .
Sample data :
add the visual :
By Months :
Use sort axis to change the sort behaviour
Please see the below pbix for reference .
Sort by Q.pbix
Thanks
If this response was helpful in any way, I’d gladly accept a kudo.
Please mark it as the correct solution. It helps other community members find their way faster - jaytrice26Helper I
That sort of helped. It looks like descending/ascending is on that is causing this issue. Is there a way to turn that off?
- Natarajan_MSuper User
Hi jaytrice26
Unfortunately, we cannot disable sorting at the visual level.
One alternative is to create a calculated column called "Quarter Sort" and use it for sorting the quarters. In the file I shared with you, you can utilize the sort column effectively.
Thanks
If this response was helpful in any way, I’d gladly accept a kudo.
Please mark it as the correct solution. It helps other community members find their way faster- jaytrice26Helper I
I switched my calendar option from Month to Month Year and it is now displaying the months in the correct order.
- Natarajan_MSuper User
Great! If it's working, could you please mark this as addressed?
Thanks
- jaytrice26Helper I
When I sort by month it moves them around but not in the correct order.
- cengizhanarslanSuper User
- Click the visual.
- In the top-right of the visual, click the three dots (⋯).
- Choose Sort by → Quarter (or Date / Quarter field).
- Select Ascending.
Sometimes quarter labels like "Q1, Q2, Q3, Q4" are stored as text. In that case you should create a numeric sort column.
Quarter Number = QUARTER('Table'[Date])Then:
-
Select the Quarter column in the model.
-
Go to Column tools → Sort by column.
-
Choose Quarter Number.
- v-prasareCommunity Support
Hi jaytrice26,
We would like to confirm if our community members answer resolves your query or if you need further help. If you still have any questions or need more support, please feel free to let us know. We are happy to help you.
Natarajan_M & cengizhanarslan, thanks for your prompt response
Thank you for your patience and look forward to hearing from you.
Best Regards,
Prashanth Are
MS Fabric community support - v-prasareCommunity Support
Hi @jaytrice26,
We would like to confirm if our community members answer resolves your query or if you need further help. If you still have any questions or need more support, please feel free to let us know. We are happy to help you.
Thank you for your patience and look forward to hearing from you.
Best Regards,
Prashanth Are
MS Fabric community support