Sort Rows of A Text Column In Matrix Visual

Anonymous · ‎02-12-2021

I am trying to sort the rows in the "Bucket To Use" column of the matrix visual in the picture below. The order should go "0 to 3", "4 to 7" , "8 to 11", "12 to 15", "16 to 19", "20 to 23", "24 to 27", "28 to 31", "32 to 35". The data powering the matrix visual is from a SSAS database. When I try to sort by the "Bucket To Use", but it does not sort correctly. It ends up looking like what's shown in the picture.

I'd appreciate any help you can offer, thank you!

parry2k · ‎02-15-2021

@Anonymous I think we are making things over complicated. It will be easier if you share pbix file using one drive/google drive with the expected output. Remove any sensitive information before sharing.

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

parry2k · ‎02-15-2021

@Anonymous you don't need that sort column in the visual but you just need to sort your bucket column with this new column, Did you had a chance to look at the post I shared?

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Anonymous · ‎02-15-2021

Are you referring to the sort by column part of the post? I tried that method by selecting both the visual and the field to be sorted by however the "sort by column" button is still grayed out. I think it might be because my data source is a live connection

parry2k · ‎02-12-2021

@Anonymous you should have another column, preferred number, and then use that column to sort bucket column, see sort by column post here.

Check my latest blog post Compare Budgeted Scenarios vs. Actuals I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Anonymous · ‎02-15-2021

Thank you for the kind suggestion. Yes, I tried to include another number field in the matrix to sort by that but I don't want the number field to actually show up in the visual