Ordering matrix by column head (column head is a custom column)

[Anonymous]

I've seen this question going around, but mine is a little bit different.

My column head is a custom column, so I can't see it in power query. The solution proposed depends on having a separate table with an index column to support the order I wish to have. Since query editing is not possible for custom columns, how can I solve this?

[Anonymous]

@v-xicai @mwegener  Here are some screenshots, I think it's quite easy to explain this way. The first screenshot ia the custom column I made with a simple IF function. That's the matrix column head.

This screenshot are two matrixes. The one on the left is the standard version using only my standard columns. The one on the right is pretty much the same info, but using the "Cap Range" column that I made. I would like it to be in crescent order (<300 kg / 300 - 600 kg / 700 - 800 kg/ > 800kg).

Thank you for the replies, hope this makes the problem clearer.

[mwegener · Accepted solution]

Hi @Anonymous 

generate another column with a SortID and use "Sort by Column"

https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column#sort-using-the-sort-by-column-button

If I answered your question, please mark my post as solution, this will also help others.

Please give Kudos for support.

[Anonymous]

@mwegener Thank you! Took a few more steps in my case but it worked!

[v-xicai]

Hi @Anonymous ,

I am not sure what desired result would you want, could you please share your sample data and desired output screenshots for further analysis? You can also upload sample pbix to OneDrive and post the link here. Do mask sensitive data before uploading.

Please read this post to get your answer quickly: How to Get Your Question Answered Quickly.

Best Regards,

Amy

Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[mwegener]

Hi @Anonymous 

could you share a sample PBIX File?

Please give Kudos for support.