Forum Discussion
Sort one column by another - messy data
This is the opposite of what you asked in the original question 🙂
And it's solvable. Here are the steps you need to take:
1. From PQ duplicate table :
2. Remove all the columns except 2 needed :
3. Remove duplicates from output description:
4. Filter out "null" (if you have)
5. Close and apply
6. create a relationship between the sort table and the main table
7. In the sorting table apply a wanted sorting logic :
8. Use the sorting table as a slicer, it will filter the main table due to their relationship :
The pbix is attached
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Ritaf1983 , I would like the order of values in my slicer to sort by the output (numerical value) and not by the output_description (text value). Here is an image of my current problem, as you can see, 13 comes after 1290
This is the opposite of what you asked in the original question 🙂
And it's solvable. Here are the steps you need to take:
1. From PQ duplicate table :
2. Remove all the columns except 2 needed :
3. Remove duplicates from output description:
4. Filter out "null" (if you have)
5. Close and apply
6. create a relationship between the sort table and the main table
7. In the sorting table apply a wanted sorting logic :
8. Use the sorting table as a slicer, it will filter the main table due to their relationship :
The pbix is attached
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Ritaf1983 , thank you so much, I did indeed mess up my original post and have edited it to prevent others from being confused. I really appreciate your help.
I'm always happy to help, and of course, my comments are not meant to be condescending or prove you wrong. Rather, I'm trying to clarify what is needed so I can better assist you 🙂