Slicer Dropdown not sorting correctly

[Anonymous]

Hello,

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

Anyone experiencing the same?

[Uzi2019 · Accepted solution]

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!

[Gabry]

Index column is data type text or number?

[Anonymous]

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

[Gabry]

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