cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Kalpana_Atkins Frequent Visitor
Frequent Visitor

Power BI slicer sort order issue

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.

 

PowerBISlicerSortOrderIssue.png
PowerBISlicerSortOrderIssue1.png 

5 REPLIES 5
Super User IV
Super User IV

Re: Power BI slicer sort order issue

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

Screenshot 2019-09-27 14.41.41.png

Kalpana_Atkins Frequent Visitor
Frequent Visitor

Re: Power BI slicer sort order issue

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

Highlighted
martyngordon Regular Visitor
Regular Visitor

Re: 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.

Kalpana_Atkins Frequent Visitor
Frequent Visitor

Re: 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?

 

PowerBI_SortIssue_12.png

martyngordon Regular Visitor
Regular Visitor

Re: Power BI slicer sort order issue

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

 

SORT.jpg

 

Click load when finished.

 

Next you need to join the two tables together on 'Name'

 

Join.png

 

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

 

dax.jpg

 

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

 

 

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Top Solution Authors