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!Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
I created a matrix, using a calculated column. The data displayed is correct, but I'd rather that my columns sort in the opposite direction.
In the screen shot below, I show the calculated column. Is there a way that I can change the calculation to sort data from left to right? If not, should I create another column using INDEX? Or maybe RANKX?
I also have a link to a similar file saved to OneDrive, in case someone wants to review.
Thanks for any suggestions!
you will need to create a custom sort column for your months, and thn go to Column tools > Sort by Column > [your calculated column].
I used the following DAX in my calculated column:
month sort = RANKX('Table', 'Table'[Month], , DESC)
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
| User | Count |
|---|---|
| 103 | |
| 80 | |
| 64 | |
| 50 | |
| 45 |