Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredCustom 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.