cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
shilpikumari_11 Regular Visitor
Regular Visitor

Date slicer is excluding blanks

Dear Team,

 

I have a date column, which I need to use as Slicer using 'between' setting. If I use the same column in a dropdown it shows me blanks but in slider it by default removing blanks. so I choose blank and any desired date range example 12/31/2018, gives me same count as excel. but when I use in between date slider, it excludes blanks.

 

why I need blanks, it's affecting my count, since Power BI removes blanks line by line so I am losing the lines which have values in other columns. please suggest. the user really needs slider as the date range is huge.

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
v-cherch-msft Super Contributor
Super Contributor

Re: Date slicer is excluding blanks

Hi @shilpikumari_11 

 

For your requirement, you may submit an idea here.

 

Regards,

Cherie

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 REPLY 1
Highlighted
v-cherch-msft Super Contributor
Super Contributor

Re: Date slicer is excluding blanks

Hi @shilpikumari_11 

 

For your requirement, you may submit an idea here.

 

Regards,

Cherie

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
GregDeckler

How to Get Your Question Answered Quickly

Power BI Super User, Greg Deckler, explains

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Ideas
Users Online
Currently online: 43 members 953 guests
Please welcome our newest community members: