Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
I am trying to sort the months (which appear in the column) of a matrix table in a paginated report. However, It does not seem to be working.
As you can see in the image below, my months are not in order.
I have also tried interactive sorting as you can see.
Any ideas or suggestions would be highly appreciated.
You need to add another column with the Month Number that corresponds to that Month's Name. Then in the Column Groups>Properties>Sorting>> Add the Month Number field to sort A-Z:
Can you please give more details .. like the dataset used which is populating month here. The sorting may need to happen at the dataset level . if possible please attach the rdl.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.