Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
andrewjmdata
Frequent Visitor

Want to allow the user to select blank from date slicer

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

3 REPLIES 3
andrewjmdata
Frequent Visitor

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
Community Support
Community Support

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
Resident Rockstar
Resident Rockstar

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?

 

Mikelytics_0-1667677252259.png

 

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.

 

 

------------------------------------------------------------------
Visit my blog datenhungrig which I recently started with content about business intelligence and Power BI in German and English or follow me on LinkedIn!

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.