Slicer not picking up specific dates

[Anonymous]

Hi Community,

I am having a problem where by my slicer does not pick some of the dates from the table.

Below is an example the table has details for 31 march 2019 but when I apply filter for 31march is shows black as if there are no details for 31 march 2019 all other dates for march 2019 works fine when I apply the filter with an exception of 31 march 2019.

Image before filtering

Image after filtering

[Icey]

Hi @Anonymous ,

Do you have any other filters? And how do you create your measures in that visual?

It would be best if you could share us a .pbix file with the same issue to test? Please remove unnecessary parts, sensitive information, real data, etc.

Reference: How to provide sample data in the Power BI Forum - Microsoft Power BI Community

Best Regards,

Icey

[Anonymous]

Hi See the link below 

https://drive.google.com/file/d/1fxkTbpnME-eo4t5QUCJ6LBfNpO251Qxq/view?usp=sharing

[Icey · Accepted solution]

Hi @Anonymous ,

The cause is on the Date table. "2019-03-31" is missing.

Go to Power Query Editor and change the code like this:

Best Regards,

Icey

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

[Anonymous]

Many thanks @Icey Icey

[daxer-almighty]

Without the file it's not possible to tell you what's wrong.

[Anonymous]

https://drive.google.com/file/d/1fxkTbpnME-eo4t5QUCJ6LBfNpO251Qxq/view?usp=sharing