Blank Date in Slicer but doesnt exist

[Xandman]

Hi

Hope someone can help, I've been looking for blank dates for 2 days now, I've found dates that were either before or after my date table but none are blank. I've also removed any relationship to the date and table I was checking, but the blank date still appears.

I created a slicer for a query linked to the date table, selected the blank and then created a table that is supposed to show the source name of the file.

[amitchandak · Accepted solution]

@Xandman , if the date table give blank, it means the date table has less data(means missing dates)

Also check , why blank - https://www.youtube.com/watch?v=23qemkDqMVY

[Xandman]

Hi everyone thank you for the help, found the sources that had problems with data yesterday, it took awhile since multiple files had different problems but was able to either delete or change their dates, had dates that weren't in my date table and some were not even dates.

[Ashish_Mathur]

Hi,

Share the link from where i can download your PBI file.

[Xandman]

I also watched this and that was why I included the source name in my query so I could find the file that had missing dates, but as seen on the screenshot, the source is also empty.

[Icey · Accepted solution]

Hi @Xandman ,

Please refer to this post to check if there are any blank records in your data table:

Blank Value in the Power BI Slicer and Filter | Encore Business Solutions.

If this doesn't work, please share us a dummy .pbix file with the same issue. Please don't contain any real data or sensitive information. In addition, it is suggested to upload your file to OneDrive for Business and then paste the link here.

Best Regards,

Icey

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

[amitchandak · Accepted solution]

@Xandman , if the date table give blank, it means the date table has less data(means missing dates)

Also check , why blank - https://www.youtube.com/watch?v=23qemkDqMVY