Power BI slicer sort order issue

Question

Hi All,&nbsp;Facing slicer sort order issue.&nbsp; 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.&nbsp;&nbsp;

anonymous · Answer

Kalpana_Atkins&nbsp; In your above example you have selected the 'ID' column and sorted that column by 'ID'.&nbsp;You need to actually define how to sort the 'Name' column rather than the 'ID' column.&nbsp;So - similar to what you have already done - select/highlight the 'Name' column and sort this column by 'ID'.&nbsp;That should do it.

amitchandak · Answer

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

kalpana_atkins · Answer

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

kalpana_atkins · Answer

Hi&nbsp; 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?&nbsp;

anonymous · Answer

Hi&nbsp;Kalpana_Atkins&nbsp;&nbsp;Yes, I understand. This has happened because there are the same 'names' across multiple 'ID' - eg, 'Options Appraisal' appears against ID 27 and 28.&nbsp;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.&nbsp;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....&nbsp;&nbsp;Click load when finished.&nbsp;Next you need to join the two tables together on 'Name'&nbsp;&nbsp;Nearly finished......you now need to create a column in the ORIGINAL TABLE.&nbsp;The code is below...&nbsp;Press 'new column' with the original table selected and type in the code below...&nbsp;&nbsp;The last step is to sort the name column as you did earlier, but this time on the new column you just created.&nbsp;So highlight the 'name' column in the original table and 'sort by column' on the new created column.&nbsp;Hope that makes sense!&nbsp;Martyn&nbsp;&nbsp;

Forum Discussion

Power BI slicer sort order issue

5 Replies

Related content

Date between slicer - Change order

slicer custom order

Slicer Ordering

Power BI Slicers

V-Order & Z-Order