Chronological order for month

[Anonymous]

I'm using a matrix in a report and is based on year and month and it shows month = April, August,.. how can I change it to show month chronologically? I'm using tabular and a seperate view in SQL server for date/time.

[tkirilov]

Hi @Anonymous ,

This should help:

https://community.powerbi.com/t5/Desktop/not-able-to-sort-by-months-in-chronological-order/m-p/61035

[Anonymous]

Thank you @tkirilov  for your answer.

The solution works if I create it in repport, but as I mentioned I'm using an SQL view for date. I created a calculated column with the formula in solution in dimension table in tabular:

=SWITCH([MonthNumber],
1,"Jan",
2,"Feb",
3,"Mar",
4,"Apr",
5,"May",
6,"Jun",
7,"Jul",
8,"Aug",
9,"Sep",
10,"Oct",
11,"Nov",
12,"Dec"
) 

but when I use this column i report it shows nothing in matrix. If I missing something?

[Tahreem24]

@Anonymous ,

Please refer the below Link to get your answer:

https://docs.microsoft.com/en-us/archive/blogs/samlester/sorting-by-month-names-in-power-bi

Don't forget to give thumbs up 👍and accept this as a solution if it helped you.

[Anonymous]

I tried with switch() and created a new column in dimension table i tabular(it shows correctly there). But it shows data in one column without any header . For example if I have values for Dec and Apr, it shows all data in one column and doesn't show header for month in report.