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
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)
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 61 | |
| 46 | |
| 40 | |
| 38 | |
| 22 |
| User | Count |
|---|---|
| 178 | |
| 127 | |
| 117 | |
| 77 | |
| 56 |