Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

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...
General Comment
Need Help
Tutorial Requests
  • Uzi2019's avatar
    Uzi2019
    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!

     

     

Anonymous's avatar
Anonymous
Not applicable
2 years ago

hi Uzi2019  : Any clue pls ?

Uzi2019's avatar
Uzi2019
Icon for Community Champion rankCommunity Champion
2 years ago

Hi Anonymous 

 

I think this is what you arelooking 

 

 

is it correct??

so i will share pbix file with you.

 

  • Uzi2019's avatar
    Uzi2019
    Icon for Community Champion rankCommunity Champion
    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!