Forum Discussion
Power BI slicer sort order issue
Hi Martyngordon,
Thank you so much for quick reply and yes, this is working with unique values ( in Name column). but here i have issue like different projects can contains same values(in Name column) for referance below is the screenshot. If possible any solution for this?
Yes, I understand. This has happened because there are the same 'names' across multiple 'ID' - eg, 'Options Appraisal' appears against ID 27 and 28.
To avoid this you need to create a separate table which contains the 'Names' and sort order which will then be linked to 'Names' in the original table.
What you need to do is create another table containing only the 'names' along with an number sequence (or sort order). So, in the HOME menu, click 'Enter Data'. You will now need to enter the data manually as follows....
Click load when finished.
Next you need to join the two tables together on 'Name'
Nearly finished......you now need to create a column in the ORIGINAL TABLE. The code is below...
Press 'new column' with the original table selected and type in the code below...
The last step is to sort the name column as you did earlier, but this time on the new column you just created.
So highlight the 'name' column in the original table and 'sort by column' on the new created column.
Hope that makes sense!
Martyn