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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
sdhn
Responsive Resident
Responsive Resident

Blank Date Values

Hi All,

 

I created a date slicer to select datae range.  By default it is disaplaying dates in both range date.

 

I want to display blank as a default so user have ability to select any date range.

 

Currently it is as below:

sdhn_0-1637265425214.png

 

I want no values but allow user to select the date from calendar.  Thanks 

1 ACCEPTED SOLUTION
v-jingzhang
Community Support
Community Support

Hi @sdhn 

 

To my knowledge, it is not able to display blank as a default. By default, it will select the whole date range of the date column that is in the slicer. You seem to be using a date column which has a range 10/1/2021 to 10/30/2021. If you want to show a wider range, you could add a calendar table which covers all possible dates you want users to select. But when a date slicer is in Between/Before/After mode, it requires at least a one-date range and cannot show blank. 

 

You could vote for a similar issue (Date Range Slicer needs to include null values too) or raise new ideas at Ideas.

 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

View solution in original post

1 REPLY 1
v-jingzhang
Community Support
Community Support

Hi @sdhn 

 

To my knowledge, it is not able to display blank as a default. By default, it will select the whole date range of the date column that is in the slicer. You seem to be using a date column which has a range 10/1/2021 to 10/30/2021. If you want to show a wider range, you could add a calendar table which covers all possible dates you want users to select. But when a date slicer is in Between/Before/After mode, it requires at least a one-date range and cannot show blank. 

 

You could vote for a similar issue (Date Range Slicer needs to include null values too) or raise new ideas at Ideas.

 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

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

Top Solution Authors