Chiclet Slicer with Week Days - Reorder

[Anonymous]

Hi,

I am using the below chiclet slicer to select the days. The top position Day 1, 2, 3, etcs are just labels. So not to worry about it.

If the day is today, then the slicer will have the value "Current Day" which has been made to select current day when we open the report. As per my logic Day 1 starts with Sunday and Day 7 ends with Saturday.

I need the days to be in correct order including the Current Day. If Current day is Sunday, then it should be in 1st position and so on for that other days too.

Please help.

[amitchandak · Accepted solution]

@Anonymous ,

Assume your column is

if( [Date] =today() , "Current Day", format([date],"DDDD")

Sort it on

if( [Date] =today() , 0, weekday([date],1))

https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column