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 Team,
I have been experiencing some issues sorting columns by months June 2017 through May 2918. They appear from january (2018) to december (2017). Going through the forum I learnt about bringing a separate table for Month ID and creating a relationship using the serial number to do the sort.
But I am still not getting the result after several attempts.
Please see pictures below for your easy reference. Would be grateful to receive your support.
Solved! Go to Solution.
Hi @Safdev,
You can create a active relationship between the fact table with month table, then set the month name sort by the desired sort order column. You can take a look at attached pbix file.
Best Regards,
Qiuyun Yu
I meant "...starting from June 2017 through May 2018". Thanks
Hi @Safdev,
You can create a active relationship between the fact table with month table, then set the month name sort by the desired sort order column. You can take a look at attached pbix file.
Best Regards,
Qiuyun Yu
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 39 | |
| 37 | |
| 33 | |
| 32 | |
| 29 |
| User | Count |
|---|---|
| 133 | |
| 88 | |
| 85 | |
| 68 | |
| 64 |