Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 discount.
Register nowCustom Visuals Ideas will be in read-only beginning Friday, Feb. 28 as we prepare to move these ideas to the new Fabric Ideas.
I would like to have the ability to sort a multi level power bi matrix by different items at different levels of the hierarchy.
for example:
at Level 1 sort by Product Group (Insurance) - asc
at Level 2 sort by Product (Home, Life, Income, Sickness, etc) - desc
at Level 3 sort by Status (Proposed, Sold, Cancelled) - asc
with a General Column sort on values or volumes - desc
The number of sorts available would be dependant on the number of levels in your matrix.
This feature would only work if the user has created sort orders in their data.
It could also be enhanced if there was a separate data type for power bi to use as a datasorting type.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.