Power BI slicer sort order issue

[Kalpana_Atkins]

Hi All,

Facing slicer sort order issue.  Given sort by column in modeling tab of data but in report it is showing default alphabetical ascending sort order. below are the screenshots for referance. Any thing i am missing or how to solve the same, any one have any ideas please help me.

 

[amitchandak]

Are you getting this after using sort option on three dots..

[Kalpana_Atkins]

yes i am, but i don't need alphabetical sort order exception was sort by Id and display same order like 

[Anonymous]

@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.

[Kalpana_Atkins]

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?

[Anonymous]

Hi @Kalpana_Atkins 

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