Forum Discussion
Power BI slicer sort order issue
Kalpana_Atkins In your above example you have selected the 'ID' column and sorted that column by 'ID'.
You need to actually define how to sort the 'Name' column rather than the 'ID' column.
So - similar to what you have already done - select/highlight the 'Name' column and sort this column by 'ID'.
That should do it.
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