The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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
Solved! Go to Solution.
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!
can you share excel based data just 2 column account + account status??
I think this is what you arelooking
is it correct??
so i will share pbix file with you.
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!
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 |
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
94 | |
94 | |
86 | |
69 | |
65 |
User | Count |
---|---|
232 | |
128 | |
116 | |
82 | |
82 |