Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
40 | |
25 | |
23 | |
19 | |
17 |
User | Count |
---|---|
50 | |
40 | |
24 | |
21 | |
20 |