Forum Discussion

Pratima's avatar
Pratima
Advocate II
9 years ago
Solved

Month Name in sorting order

Hi All,   I want Month Name to displayed like in ascending or descending order not like this             Thanks, Pratima
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • tjd's avatar
    tjd
    9 years ago

    Go to the database tab, select month name column from your calendar table.  Select the modeling tab and then "Sort by Column" and select your month number column.  Month name should now appear in the correct order.

Pratima's avatar
Pratima
Advocate II
9 years ago

Thank you Tjd for the valuable answers.....

 

Now i am getting the expected result

 

 

Thanks,

Pratima

 

matthewtmitchel's avatar
matthewtmitchel
Frequent Visitor
8 years ago

I am running Power BI Desktop version 2.51.4885.701 and do not have a Database tab.  I have Home, View, Modeling, and Help.  Do you mean the Modeling tab?  If not, is there a different way to sort in numerical month order, instead of alphabetical month order?

  • tjd's avatar
    tjd
    Impactful Individual
    8 years ago

    Sorry, tab is probably the wrong term, view would be more appropriate.  Within PowerBI Desktop, you have 3 icons on the left.  The top one is the visualization view, next is the data/database view, and the third is the relationship view.  Click on the data/database view and then follow the above instructions.  

    • KarenOden's avatar
      KarenOden
      New Member
      8 years ago

      I have the same problem but the way I get my data into Power BI is with a live connection to Microsoft Analysis server. So I don't have a database view. How do I do it?

      • miltenburger's avatar
        miltenburger
        Helper V
        8 years ago

        I have the same problem, i'm using a live connection to a Analysis Service. So i don't see the three tabs on the left.

        Anyone got a solution for this?