Date Slicer Between Behavior for null value date

[WendyDUFE]

Hi, 

I have the date slicer in my report, and to make it user friendly , I use the between date type so user can easily adjust the date using the scroll bar. 

But for some of the data, the date is null, in this case, I observed belong confusing behavior 

1) Select the date out of the from and to range  (2021/04/06 ~ 2021/12/23 )

1-A): Select the Date-To date later then the max date, the column chart shows all the records  

1-B): Select the Date-From date earlier then the min date, the column chart shows only the not null date records. Data records with whose date is null, are not included in the column chart. 

Then I choose the Start-date (2021/4/6) manually, but the column chart still exclude the two null date value records

2)  Select the date within the from and to range  (2021/04/06 ~ 2021/12/23 )

2-C)  Select the Start Date later then the min date , the data with null date and date not in this new data range are excluded in the column chart 

Then I select the min date again (2021/4/6),  and the column chart has all data back, including the null date records. 

2-D) Select the To-Date earlier then the max date , the data with null date records are still showing on the column chart, but only date not in this new data range are excluded in the column chart 

Then I select the original Date-to , the column chart will show all the records again 

Question: I wanna know what is the logic when dealing with null date value in the data slicer interaction with the visuals on the canvas. Current behavior is very confusing, some cases the null date value records are showing, but some cases not. 

Is that any configurations or options to make sure as long as user select the from-date / to-date to the original one, then the column chart will show all records ? 

Thank you 

[aqsa31]

Hi @WendyDUFE I know its an old post but did you find any solution for that? I am stuck in this exact same problem

[v-shex-msft]

HI @WendyDUFE,

It is hard to clarify and troubleshoot your issue from the screenshots. Can you share a pbix file with some dummy data with the similar data structure to help us clarify these scenarios? 

How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng

[amitchandak]

@WendyDUFE , if you null/blank in dates and that is joined with other table (Say Date) , it better to exclude that in measure or at the visual level filter.

Also make sure these null value are not coming because 1 side of the tbale in join have less values

Also check if this video from guyincube can help

https://www.youtube.com/watch?v=o8K4Px_6AYQ