Want to allow the user to select blank from date slicer

[andrewjmdata]

Hi, Am working on a PBI project which reports on data for an online commercial repairs system.

I have a "completedDate" field which the user wants to have on their report. As most of the data, repairs, are is NOT completed, they also want to be able to select BLANK value in the "completedDate" slicer. 

Ideally what I would want to see is the between dates they are used to, but is there an option/something I can set up to allow the user to select a blank date?

Thanks

Andrew

[andrewjmdata]

Thanks Michael, I've gone with what you suggested. Was hoping there was something else I could do but I guess it's fine.

Cheers

Andrew

[v-luwang-msft]

Hi @andrewjmdata ，

Has your problem been solved, if so, please consider Accept a correct reply as the solution or share your own solution to help others find it.

Best Regards
Lucien

[Mikelytics]

Hi @andrewjmdata ,

Normally when you put a field with blank values in a slicer then blank should be an available option.

Can you please share a picture of your data model / table as well as a picture of a slicer with the completion date in it? 

Which type of slicer to you use? Did you set the slicer on dropdown or something else?

Best regards

Michael

-----------------------------------------------------

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Appreciate your thumbs up!

@ me in replies or I'll lose your thread.