Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to 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.
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.
Note that Date field is not linked to anything in relational table design. Thank you in advance.
User | Count |
---|---|
101 | |
90 | |
82 | |
76 | |
71 |
User | Count |
---|---|
113 | |
104 | |
100 | |
73 | |
65 |