Sort Rows of A Text Column In Matrix Visual

[Anonymous]

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]

@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.

[parry2k]

@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?

[Anonymous]

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]

@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.⚡

[Anonymous]

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