Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.