How to sort a dynamic slicer values based on the another column?

[Anonymous]

HI Experts,

I have a scenario like apply some filters on slicer to sort the values.

Here for example : i am having a slicer with account names which will be increaing when new accounts are added and by default we have a sorting methods like asc & desc in visual itself.

I have a coulmn like account status : OPEN & CLOSED

So based on this account types , the slicer will give the order .

OPEN accounts should come on top & CLOSED accounts are all comes after that .

Below the account names slicer i have , this is in alphabet orders now.

OPEN accounts are comes on top & CLOSED should come after that . this is the scenario.

Please help to sort this asap ?

Thanks

DK

[Uzi2019]

hi @Anonymous 

can you share excel based data just 2 column account + account status??

[Anonymous]

hi @Uzi2019  : Any clue pls ?

[Uzi2019]

Hi @Anonymous 

I think this is what you arelooking 

is it correct??

so i will share pbix file with you.

[Uzi2019 · Accepted solution]

Hi @Anonymous 

go to power query editor then Sort the Status by Desc then sort the Account by Asc.

then got to add column tab > then index column> 

index column is added 

save and close power query editor

then select account column > then sort by column option > select index

then take you slicer add account column you will get sorted order data

I hope I answered your question!

Attaching pbix for reference!

[Anonymous]

Hi ,

I cannot attach any file here , so just putting the data below :

Account	Status
Arval	Open
Tetra Laval Credit AB	Open
SIDEL SERVICES	Open
Zentiva Group, a.s.	Open
Outokumpu Oyj	Open
Altair Global Relocation	Closed
CBRE, Inc.	Closed
CBS	Closed
Cisco Systems, Inc.	Closed
Discovery Communications, LLC	Closed
Worley	Closed
Educational Testing Services	Closed
Wells Fargo	Open
Warner Bros. Entertainment Inc.	Closed
FedEx Corporation	Closed
UiPath Inc.	Closed
Fluke Corporation	Open
UBS AG	Open
Stanley Black & Decker, Inc.	Closed
Staples Inc	Closed
Hydro One Networks Inc	Closed
STIHL	Closed
Stryker	Closed
Internal Automation	Open
INTERNATIONAL PAPER COMPANY	Open
Schneider Electric SA	Open
Metlife Japan	Open
KI Wissen	Open
Konecranes Abp	Open
Google Inc.	Closed