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...
  • 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!