Forum Discussion
Solved
Ordering by month name
Hi, I have a date table which I'm using in my report. It contains columns for month number and month name. I've used the month name in my report but it sorts in alphabetical order. Is there any w...
Hi runnerpaul
1. In PBI desktop select the Date tab (menu bar on the left side of the screen)
2. Select your period table
3. Select your month name column
4. On the modeling tab select "Sort By Column" in the top menu and pick your month number column.
sdjensen
Solution Sage
Solution SageHi runnerpaul
1. In PBI desktop select the Date tab (menu bar on the left side of the screen)
2. Select your period table
3. Select your month name column
4. On the modeling tab select "Sort By Column" in the top menu and pick your month number column.
Great!!!