Forum Discussion
JustinDoh1
Post Prodigy
5 years agoSort date using shortened month name
I have modified the month name to be displayed as three characters, then I realized that if I use that calculated column, it would not display by month order (Jan.. Dec), but by alphabetical order (A...
- 5 years ago
You will want to add a date table to your model, they you have a column called something like Month Year in there that uses the date of the last day of the month (it's date so it sorts correctly) but you format it like mm-yyyy so it also displays correctly. Here is an article talking about specifically the problem you are trying to solve.
https://www.sqlbi.com/articles/creating-a-simpler-and-chart-friendly-date-table-in-power-bi/
jdbuchanan71
Super User
4 years agoYou would join the date table into your fact table, yes.
JustinDoh1
Post Prodigy
4 years agojdbuchanan71 Thank you for your feedback/help.