How to sort the slicer order ascending in power bi service RLS view

[Anonymous]

I have a report that I develop myself and publish online for users to view. Here RLS is done dynamically, I have selected a column for slicer-applied single selection on it, I have sorted the order to A to Z in slicer,but in the final power BI service RLS view for few users showing sorting order as Z to A ,

How we can make the order selection A to Z for all users?

[v-zhenbw-msft]

Hi @Anonymous ,

We have a test and the sort worked fine.

Maybe you can create a new table to sort it based on a number column.

1. Create a table using enter data.

2. Then create the relationship between sort table and your fact table.

3. Create a slicer based on column1 in Sort table, then use sort by column.

If it doesn’t meet your requirement, could you please provide more detail about the issue? Some screenshots or sample pbix is fine.

Please don't contain any Confidential Information or Real data in your reply.

Best regards,

Community Support Team _ zhenbw

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