Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Slicer has (blank) but no missing data

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.  
Need Help
  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    3 years ago

    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.

     

     

v-yanjiang-msft's avatar
v-yanjiang-msft
Icon for Community Support rankCommunity Support
3 years ago

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.