Forum Discussion
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
- Uzi2019Community 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!
- GabrySuper User
Index column is data type text or number?
- AnonymousNot applicable
It's currently a Decimal Number. The numbers are created using the "Index Column".
- GabrySuper User
OK then I have no clue. Already tried to deselect the "industry portfolio" and reorder?