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 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

 

 

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!

     

     

5 Replies

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

    hi Anonymous 

     

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

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Hi ,

       

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

       

      AccountStatus
      ArvalOpen
      Tetra Laval Credit ABOpen
      SIDEL SERVICESOpen
      Zentiva Group, a.s.Open
      Outokumpu OyjOpen
      Altair Global RelocationClosed
      CBRE, Inc.Closed
      CBSClosed
      Cisco Systems, Inc.Closed
      Discovery Communications, LLCClosed
      WorleyClosed
      Educational Testing ServicesClosed
      Wells FargoOpen
      Warner Bros. Entertainment Inc.Closed
      FedEx CorporationClosed
      UiPath Inc.Closed
      Fluke CorporationOpen
      UBS AGOpen
      Stanley Black & Decker, Inc.Closed
      Staples IncClosed
      Hydro One Networks IncClosed
      STIHLClosed
      StrykerClosed
      Internal AutomationOpen
      INTERNATIONAL PAPER COMPANYOpen
      Schneider Electric SAOpen
      Metlife JapanOpen
      KI WissenOpen
      Konecranes AbpOpen
      Google Inc.Closed
      • 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.