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.

     

     

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

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

  • 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.