Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Slicer Dropdown not sorting correctly

Hello,

 

My Dropdown does not adjust to my ranking (using "sort by column")

 

Anyone experiencing the same?

 

 

  • Hi Anonymous 
    Just append 1 2 3 4 in front of your value stream name.

    Like below.

    I have this data 

     

    I want to sort according my my prefrence.

    I have created calculated column.

    Sorting = SWITCH(TRUE(),
                WOW[Campaign Type]="SPONSORED_DISPLAY", "1.SPONSORED_DISPLAY",
                WOW[Campaign Type]="SPONSORED_PRODUCT","2.SPONSORED_PRODUCT",
                WOW[Campaign Type]="SPONSORED_BRAND_VIDEO","3.SPONSORED_BRAND_VIDEO",
                WOW[Campaign Type]="SPONSORED_BRANDS","4.SPONSORED_BRANDS"
                )
     

     

     

    take you calculated column in slicer. 

     

    I hope I answered your question!

     

4 Replies

  • Uzi2019's avatar
    Uzi2019
    Community Champion

    Hi Anonymous 
    Just append 1 2 3 4 in front of your value stream name.

    Like below.

    I have this data 

     

    I want to sort according my my prefrence.

    I have created calculated column.

    Sorting = SWITCH(TRUE(),
                WOW[Campaign Type]="SPONSORED_DISPLAY", "1.SPONSORED_DISPLAY",
                WOW[Campaign Type]="SPONSORED_PRODUCT","2.SPONSORED_PRODUCT",
                WOW[Campaign Type]="SPONSORED_BRAND_VIDEO","3.SPONSORED_BRAND_VIDEO",
                WOW[Campaign Type]="SPONSORED_BRANDS","4.SPONSORED_BRANDS"
                )
     

     

     

    take you calculated column in slicer. 

     

    I hope I answered your question!

     

    • Anonymous's avatar
      Anonymous
      Not applicable

      It's currently a Decimal Number. The numbers are created using the "Index Column".

      • Gabry's avatar
        Gabry
        Super User

        OK then I have no clue. Already tried to deselect the "industry portfolio" and reorder?