Tuesday, September 27, 2016

How to sort month names in Power BI

When names of months used in Power BI you'll be able to sort this A-Z or Z-A. Both do not give the correct order:


or Z-A

This problem can be solved in some simple steps. 

Step 1 - Add a month number column to your dataset, like this:

Step 2 - Click month column in data tab of Power BI, like this:

Step 3 - Go to the modeling tab and click Sort By Column, like this:

Step 4 - Click MonthNr in the drop down

Now your report looks like this