Slicer has (blank) but no missing data

[Anonymous]

Hello,

I found out that there exists one (blank) option in a Date slicer

 Yet in the database there is no other options other than 2022-10-04.

 

[v-yanjiang-msft · Accepted solution]

Hi @Anonymous ，

Usually this situation happens if your relationship tables contains records who can't correct mapping to related table, it will shows value as 'blank' option in slicer.(blank option means the missing records).

To fix it, you can drag your DATE column to the page level filters. select all and uncheck the blank option.

You can also refer to the solution in this blog: Blank Value in the Power BI Slicer and Filter - Encore Business Solutions

Best Regards,
Community Support Team _ kalyj

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

[Anonymous]

Note that Date field is not linked to anything in relational table design. Thank you in advance.