Select and hide "blank" in a date slicer

[Anonymous]

Hello, everyone,

I have the following slicer:

Currently I have to select "One date + Blank values" to get all data.

If I don't select "Blank", I'm missing data.

Is there a way to hide the "blank" in the slicer but still include it in the data?

I just want to see the timestamps without "blank". And then I want to select exactly one date from these.

I'm looking forward to your messages.
Best regards 🙂

[Anonymous]

Hi @Anonymous ,

Have you tried doing such a filter on the slicer? How is the result?

Best Regards,
Community Support Team_Gao

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data

[amitchandak]

@Anonymous , You can hide using visual level filter. Ideally blank should be there, but you can create a measure to add blank values

You should check why there is blank value. I think you date table is missing dates

[Anonymous]

@amitchandak 

If i filter the slicer with "is blank" than dates are not visible.