Forum Discussion

NPArulventhan's avatar
NPArulventhan
New Member
10 years ago
Solved

How to sort month in order ?

Thanks advanced !!!
 
My month field show in alphabatic order , how can i sort in correct order . pls help me, its quick call

 


  • Cool...


    Choose your Dimesion and then click the modelling ribbon there u can find the "Sort by Column" from that u can choose based on what measure u want to sort .


    it will solve your prob if not let me know i will help u ;-)

4 Replies

  • Baskar's avatar
    Baskar
    Icon for Resident Rockstar rankResident Rockstar


    Cool...


    Choose your Dimesion and then click the modelling ribbon there u can find the "Sort by Column" from that u can choose based on what measure u want to sort .


    it will solve your prob if not let me know i will help u ;-)

    • BreeC's avatar
      BreeC
      Regular Visitor

      Why is the sort option greyed out on my modeling ribbon?

      • BreeC's avatar
        BreeC
        Regular Visitor

        I got my report to sort:

        Choose a field under the fields list and click on it so that it is highlighted. 

         

        Navigate to the Modeling ribbon and click on the sort by column. 

         

        You will see that the month field (this is what I selected) that was selected is now shown as the default. 

         

        Select the field that you want to sort by (I have a field called MonthSort).  This field has the month number, but the month field displays the month in words.  After this field is selected, the report sorts. 

         

    • Anonymous's avatar
      Anonymous
      Not applicable

      Hi Baskar

       

      Please can you share the screen shots. I'm new to Power BI and I cannot find the Modelling Ribbon.

      Appreciate if you can share the screen shots.

       

      Thanks

      Mahad