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:

A-Z


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