Forum Discussion

jaytrice26's avatar
jaytrice26
Helper I
5 months ago
Solved

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? 

 

  • jaytrice26's avatar
    jaytrice26
    5 months ago

    I switched my calendar option from Month to Month Year and it is now displaying the months in the correct order.

     

     

9 Replies

  • 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



  • That sort of helped. It looks like descending/ascending is on that is causing this issue. Is there a way to turn that off?

  • 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



    • jaytrice26's avatar
      jaytrice26
      Helper I

      I switched my calendar option from Month to Month Year and it is now displaying the months in the correct order.

       

       

      • Natarajan_M's avatar
        Natarajan_M
        Super User

        Great! If it's working, could you please mark this as addressed?

        Thanks 

  • When I sort by month it moves them around but not in the correct order.

     

    1. Click the visual.
    2. In the top-right of the visual, click the three dots (⋯).
    3. Choose Sort by → Quarter (or Date / Quarter field).
    4. 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:

    1. Select the Quarter column in the model.

    2. Go to Column tools → Sort by column.

    3. Choose Quarter Number.

  • v-prasare's avatar
    v-prasare
    Community 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-prasare's avatar
    v-prasare
    Community 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