Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Hi all,
I am trying to sort my Calendar Table to display properly. My Column is MMM, YYYY.
I tries soerting by year then month number but that give me either
Jan, 2011
Jan, 2012,
Jan, 2013
or
Apr, 2011
Aug, 2011
Dec, 2011
How can I sort so displays
Jan, 2011
Feb, 2011
Mar, 2011
Thanks,
-w
Solved! Go to Solution.
Hi @UncleLewis
With in my Date table I created a Month Index column and converted then to number
Month Index = Format('DIM Date'[Date], "YYMM")
I then Sorted the MMM, YY column by this index Month. As it is taking the year first, it will sort properly
Thanks
Joe
If this post helps, then please Accept it as the solution
Hi @UncleLewis
With in my Date table I created a Month Index column and converted then to number
Month Index = Format('DIM Date'[Date], "YYMM")
I then Sorted the MMM, YY column by this index Month. As it is taking the year first, it will sort properly
Thanks
Joe
If this post helps, then please Accept it as the solution
Hello @UncleLewis ,
Refer to this video https://youtu.be/yx-Duj_KPtw?si=CgODPULaMw7xqJEH
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Follow me on Linkedin
Vote for my Community Mobile App Idea 💡
Proud to be a Super User! | |
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 56 | |
| 45 | |
| 35 | |
| 34 | |
| 21 |
| User | Count |
|---|---|
| 143 | |
| 122 | |
| 100 | |
| 80 | |
| 57 |