Sorting Slicer by Another Column Problem

[NadaKiju]

I have read article after article on how to sort a slicer by another column, but all these articles were several years old. I saw that there was an issue with this in the October 2020 release and that Microsoft fixed this with the most recent update so I have installed the most recent version and still cannot figure it out.

My end goal is to set up a "password" in Power BI that will direct the user to a hidden sheet based on the value they enter (full instructions here: https://www.capstoneanalytics.com.au/can-you-password-protect-a-power-bi-report/). I have created the three tables and am sorting the table based on the Order column. Now I am trying to put the rows in three slicers to replicate a keyboard layout. This is what I am trying to achieve: 

Unfortunately, this is what I am getting: 

This is what one of my tables looks like (the other two are the same setup).

What do I need to do in order to sort the slicers by my "Order" column so that they mimic the layout of a keyboard?

[v-yangliu-msft · Accepted solution]

Hi  @NadaKiju  ,

I downloaded your pbix document, after the following operations:

1. Select Row1, select Column tools-Sort by column, select Order1

2. Choose Sort ascending.

3. Result.

Is your Power bi Desktop the latest version? This is my Desktop version:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[NadaKiju]

AH! I was going through these steps but was clicking on my Order by column and then doing the sort by column. I did it by clicking on Row1 and it is working perfectly. Thank you so much!

[amitchandak]

@NadaKiju , This should be a bit darker if clicked. Check that. Also, on three dots on visual check it is sorted and sort asc

[NadaKiju]

I selected it again to be sure, but it still doesn't appear darker. I resorted my slicer by ascending just now and it remains in the same order. 

[amitchandak]

@NadaKiju ,Can you a sample pbix after removing sensitive data.

[NadaKiju]

Gladly! It looks like I don't have the ability to attach the file, but I uploaded the file to Google Drive: https://drive.google.com/file/d/1FCysBfpCPO5CGQMNwNYWFC4zRrHLqwtH/view?usp=sharing