Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to Solution.
Hi @Anonymous
generate another column with a SortID and use "Sort by Column"
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.
@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.
Hi @Anonymous
generate another column with a SortID and use "Sort by Column"
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.
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.
Hi @Anonymous
could you share a sample PBIX File?
Please give Kudos for support.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
80 | |
69 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |