Forum Discussion
Sorting Slicer by Another Column Problem
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?
Hi Anonymous ,
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.
6 Replies
Anonymous , This should be a bit darker if clicked. Check that. Also, on three dots on visual check it is sorted and sort asc
Anonymous ,Can you a sample pbix after removing sensitive data.
Hi Anonymous ,
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.
