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?    
  • Uzi2019's avatar
    2 years ago

    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!