Change order of options on Desktop Slicer

[Anonymous]

Hi

In a simple Reort like this, how coudl I change the order of the "Account" slicer, e.g. move key account 983 to the top?

Example at https://1drv.ms/u/s!AmxJyApgEAcYgu4rR2TmBECZU7C3JQ

Thanks!

[judspud · Accepted solution]

Hi @Anonymous 

One way i have achieved this was to add another column to the table which has the numeric order of the accounts.

I created another table using enter data and assigned values, i then merged this table with the other and sorted the original column by the new numeric order.

Hope this helps

Thanks,

George

[v-piga-msft · Accepted solution]

Hi @Anonymous ,

By my test with your pbix, it seems that the easiest way is sort the slicer Account like below.

Actually, the suggestion of HotChilli  and judspud are helpful either.

If you have solved the problem, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

Best  Regard,

Cherry