Sorting Days name in chiclet slicer on the base of date

[Anonymous]

HI Team,

I have Day Name like Mon, Tue,Wed,Thu,Fri,Sat,Sun,Mon which si for today + last 7 days. So If today is Wed then it should repeat in slicer. These day names are based on date called Delivery Date. Now the whenver I select the Day Name in Chiclet Slicer it gives me only 7 names like 

Wed,Thu,Fri,Sat,Sun,Mon,Tue- Here being Mon is duplicate(but date is different) its showing Wed only once

But I need 

Wed,Thu,Fri,Sat,Sun,Mon,Tue,Wed

If I add delivery date in Image section in Chiclet Slicer it works fine but the display is not something user want to see.The image above day name is not to be displayed

But when I remove Delivery Date from image section of Chiclet it shows me as below: Where sorting gets disturbed and also Wed is reflecting only once.

Any suggestions?

Thanks

[parry2k]

Slicer display unique value, I guess if you concatenate date with your day or something to make it unique, it will repeat.

[Anonymous]

Still same issue as I dont want to display date but just Day Name.

[v-yulgu-msft]

Hi @Anonymous,

It is not possible to display just duplicate Day Name in slicer as slicer always lists unique items. In your scenario, one workaround could be adding an index column and combine index with Day Name, something like: new column=[Index]&"-"&[Day Name]. Place this new column into "Category" of chiclet slicer.

Best regards,

Yuliana Gu