Forum Discussion
Helper IBlank values in date slicer
Hi，mr_oli
Please make sure your Date table cover all dates in the date field，and there are no null / blanks present in the date field.
Also check you don’t have different Date Time values in the field.
For this situation ，the solution was that the join to the Date table was to a date time field. Joining to a date only field may resolved the issue.
Hope it helps.
Best Regards,
Caitlyn Yan
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Community Championmr_oli I guess one side of your table relationship does not have matching value that is why blank is appearing in your slicer. You may refer to below blog for help
That blog post at Encore Business was the only place I found that explained the issue simply and had recommended steps to find the bad data and solve it. Thank you 🙂
