Unable to sort months in PowerBI

[Pranav13]

Hello All,

I am having a data set with months and software usage for the each month. Once I plot it in PowerBI the months are taken in alphabetical order and not by Month.

Can you please help me to sort the months like January,February,march etc.. instead of alphabetical order.

The sorting option for the same is not seen in Power BI.

The columns details below:

Column 1 - Months (Jan,Feb,March,April..)

Column 2 - Number of Softwares used (Eg: 10,20 30 40)

Kindly help to sort he data as per my need.

[cmaier]

without seeing the data structurr its hard to know exactly the problem, but my first thought is that PBI doesn't know those are time series data. My first suggestion (and maybe you've done this) is to have a 'Date' table and have a month column in that table. If you want Month names I *think* Month=format('Date'[Date',"MMMM") should work (the exact notation might be wrong, but you get the idea. Then form a relationship between this month column and the month column in your original data. That might help with the sort issue. A second solution would be to alter your original Month column so it say "1-Jan", "2-Feb" etc. then sorting the axis should put them in numerical order.

[Pranav13]

@cmaier My Month column Data is - Jan-2024, Feb-2024, Mar-2024 .. like that till July-2025. So when I plot with this data the months are populated in alphabetical order and not with the normal January to decemeber. My expectation is my data has to populate from January till December

[duarte]

Boa noite! Neste caso, voce faz uma condição de dax para obter o numero daquele mês (Segue dax: month(sua data ref)). Em seguida, você vai selecionar a coluna que vc quer por na ordem (neste caso sua coluna de mês) e vai seguir este passo: Modo de exibição de tela (é onde conseguimos enxergar as informações carregadas) -> Ferramenta de Coluna -> Classificar por coluna E vai escolher classificar pelo numero do mês. Conclusão: Sua coluna de mês será classificada de acordo com a ordem do menor para o maior mês, ex: Janeiro - 1 Fevereiro - 2 Março - 3 Etc.