Forum Discussion
How to customise sorting range values in Matrix?
Create a sort order calculated column in the same table:
PO Range Sort = SWITCH ( TRUE (), 'Purchase Orders and Items'[Total Order Value] <= 1000, 1, 'Purchase Orders and Items'[Total Order Value] <= 5000, 2, 'Purchase Orders and Items'[Total Order Value] <= 10000, 3, 'Purchase Orders and Items'[Total Order Value] <= 25000, 4, 'Purchase Orders and Items'[Total Order Value] <= 50000, 5, 'Purchase Orders and Items'[Total Order Value] <= 250000, 6, 'Purchase Orders and Items'[Total Order Value] <= 1000000, 7, 8 )Then apply Sort by Column:
Select the PO Range Value column → Column tools → Sort by Column → PO Range Sort
Super UserHi UrbanCK,
Issue is that it is considering PO range values as text and not as numeric values, to overcome this PO range column should be sorted by another column, Refer attached .pbix solution file, I've created a new column PO Range sort and then sorted PO range value column by PO Range sort column and getting the correct output in Matrix visual.
For sorting select PO range value column and then go to sort by column and select PO Range sort (refer screenshot below)
🌟 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!