Forum Discussion
Anonymous
2 years agoNot applicable
How to sort a dynamic slicer values based on the another column?
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...
- 2 years ago
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!
Uzi2019
Community Champion
2 years agohi Anonymous
can you share excel based data just 2 column account + account status??
Anonymous
2 years agoNot applicable
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 |