Forum Discussion
Sorting a matrix visual based on a measure
Hi Manish1198,
You can create a helper measure to sort the matrix by Office Supplies - Quantity only.
Sort by Office Supplies Quantity =
CALCULATE(
SUM(Orders[Quantity]),
Orders[Category] = "Office Supplies"
)
-
Add this measure to your matrix (you can hide the column visually later if needed).
-
In the matrix, click on the column header Sort by Office Supplies Quantity.
-
Set Descending.
-
Then remove the column from the visual if you want, or just hide it.
🌟 I hope this solution helps you unlock your Power BI potential! If you found it helpful, click 'Mark as Solution' to guide others toward the answers they need.
💡 Love the effort? Drop the kudos! Your appreciation fuels community spirit and innovation.
🎖 As a proud SuperUser and Microsoft Partner, we’re here to empower your data journey and the Power BI Community at large.
🔗 Curious to explore more? [Discover here].
Let’s keep building smarter solutions together!
Hi grazitti_sapna
The helper measure you mentioned cannot be put in columns section.
When put in Values section, it makes the visual as following. I would need the visual as share in the above request with possiby sorting based on Office supplies quantity.