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

[v-piga-msft]

Hi @Anonymous ,

Have you solved your problem?

If you have solved, 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.

If you still need help, please share your data sample and your desired output so that we could help further on it.

Best  Regards,

Cherry

[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

[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

[Anonymous]

Hi George

I'm struggling to understand your solution.

I've added a key to the "Account Order" table:

It's linked to the "Account" on "Four County Sales"

.. but I can't work out what to do next. Could you please advise?

Report is at

https://1drv.ms/u/s!AmxJyApgEAcYgu4rDq7HzwHv2VLuqQ?e=PTCqe6

Thanks!

[HotChilli]

https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column#sort-using-the-sort-by-column-butto...

[Anonymous]

Hi Hotie

Thanks for this but I don't think it addresses my problem, i.e. how do I do a non-standard sort on a slicer in Power BI

Sorry for late response, I've been away.

OHB

[HotChilli]

"I don't think it addresses my problem"  - Your problem is that you want to order the slicer by the KeyX field (in reverse I think). Is that right?

It would look like this :

[Anonymous]

I want to sort the slicer into a non-standard order, rather like in an Excel Advanced Sort, for example in the sequence:

983

982

981

984

985

.. which is neither ascending nor descending. 

[HotChilli · Accepted solution]

OK, you need to use the 'Sort by Column' functionality but you need a column in the AccountOrder table that defines that order.  I thought that was what KeyX is for.  If it is for that purpose then you need to change the data so that KeyX defines the order you want.  If KeyX is not for that purpose then add an 'Order' column.

Once you have the column (and it should be a number data type) , you select the AccountX column in the field list and Click the 'sort by column' button on the Modelling tab. You then choose the column to sort by.

This can be a little flaky sometimes when the button is not enabled or the visual needs refreshing but it will work.

[Anonymous]

I think this works