Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
So I have this table matrix, and I'm trying to sort the agency from A-Z, which should result to BSMI as first value, I also checked the more option [attached below]
Please help
Solved! Go to Solution.
Try putting the URL link field after the agency field.
Hi @mrlnbcln ,
Sorting in matrix happens within a hierarchy. In your case, each item in Agency is being sorted within its own Model and URL group.
Proud to be a Super User!
Try putting the URL link field after the agency field.
it works! Thank you so much, but I'm wondering why. Do you have explanation?
@danextian explains it well. The sorting happens down through the hieararcy based on the order of the fields in the matrix so your Agency were being sorted by the URL.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
112 | |
108 | |
102 | |
94 | |
71 |
User | Count |
---|---|
173 | |
134 | |
132 | |
102 | |
95 |