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!View all the Fabric Data Days sessions on demand. View schedule
Below is the screenshot where left part is the data, and right part is the result.
I need to sort the columns descending (i.e Budget 2018 , 201801, 201802, 201803)
The visual used here is the matrix. (pivot table)
I have tried sorting with the index column, but still not able to get accurate result.
Any help is appreciated,
Thanks in advance !!
Solved! Go to Solution.
@Anonymous ,
Change the Index of "Budget 2018" from 4 to 0.
@Anonymous ,
Change the Index of "Budget 2018" from 4 to 0.
Thanks @v-chuncz-msft!! ,
It worked, but this is quick fix.
What if I receive data for "2020" and "budget 2020" again I need to put indexing and change the index manually.
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!