Forum Discussion
Sort non unique values by another column
pimo it doesn't matter what column you are sorting by, logic remains the same, same name cannot have two different sort by column values. That's it.
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos 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.⚡
Ok, but I was hoping thare was a trick...
For example sort (unique) ID by SortingNumber but "display" Name instead of ID.
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos 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.⚡
pimo Here's a trick I've found works (and for the benefit of anyone else ending up here with the same problem):
Add a new calculated column:
NameExtended = [Name] & REPT(" ",[Sorting Number])
Set the sort order of this column to your Sorting Number column and use it, rather than [Name], in your slicers.
The spaces added to the end of the name won't show in the slicer, but they effectively make each name instance unique.
Job done!