Forum Discussion
Community ChampionMonth Columns in PBI Desktop
We're currently working on this for the desktop .... and it will be a unified experience in both the desktop and service. There are several date time features that will show up. This kind of automatic behavior is among the first that will arrive.
Advocate IIIYou sound upset. It is possible to sort visualisations and tables properly, even if only the month name is being used.
Start in the query and add a custom column called DateSort with this M formula:
=Date.ToText([Date],"yyyyMM")
Replace [Date] with your desired date field. The new column will show the values like in this example. Note how the order is not chronological in the query.
Close and apply the query and go to to data tab and click the Modelling ribbon. Select the Month Name column, click the "Sort by Column" dropdown. Select the DateSort column you just created.
Now you can create data visualisations, charts or tables, where you use just the month name. If you sort by that month name, the result will be chronological, not alphabetical or only by month number. Not in the screenshot how February is at the bottom because it is a date in 2017, whereas all other dates are in 2016. For your benefit, another table shows the full date.
If that is not what you are trying to achieve, maybe you could politely explain your details.
Teylyn,
Your solution is by far the best. and the only one posted here that works. Good work.
Anthony