Slicer configuration questions

[bergen288]

I have a dimentional table with Date column in last 7 days sorted in descending order.  It is used as a slicer to allow user to select particular date in last 7 days.  Why is date not sorted in descending order in my slicer and how to do it? There is no blank in the table, why is there a blank in slicer and how to remove it?  How to select last date (Jan 8 2023) as default, or last weekday (Jan 6) as default?

[Idrissshatila · Accepted solution]

Hello @bergen288 ,

You click at the three dots on the slicer and then sort it as in the screenshot

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin

[bergen288]

Great, the sort issue is resolved.  How about other questions?

There is no blank in the table, why is there a blank in slicer and how to remove it? This is because my fact table has 91 days.  If blank is selected, all 91 days will show up so I would like to remove blank.

How to select last date (Jan 8 2023) as default, or last weekday (Jan 6) as default?

[Idrissshatila]

Hello @bergen288 ,

You can unselect it from the filter pane of the slicer

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin

[bergen288]

Great, the blank is removed.  How about default selection?