Sort matrix by measure..but 2nd level rows ignore ...

codyraptor · ‎02-07-2023

Hey everyone. I have a simple matrix that sorts by volume. I also have a time calculation group for Current and PY and the ordinal is set to the correct sort order. However...sorting the Matrix overrides the sort order of the calculation group. Is there a way to sort the matrix by the volume measure...but ignore the sort for the calculation group?

amitchandak · ‎02-07-2023

@codyraptor , If sort of volume, it should sort ascending or descending at each level based on volume

But if you sort on Column- the company then it will follow the sort order

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview. ✨
️ November 12th-14th, 2024
 Online Event
Register Here

Sort matrix by measure..but 2nd level rows ignore sort

Helpful resources

Fabric Community Update - November 2024

Be one of the first to start using Fabric Databases

Join us at the Microsoft Fabric Community Conference

Power BI Monthly Update - November 2024

Be one of the first to start using Fabric Databases.