PBI recognise data fields with blank, when they don´t exist

[SMOYAMI]

Hello community, 

This is my first time posting, so sorry if i don´t find the right place to add the post.

This is, I am sure, a very simple question but i am totally blocked. I have an excel table with 4 simple columns, one of them a date column that embrace dates between 2016 and 2020.

When i add a slicer, it does not recognice al the row date totally, and give me back a big amount of blanck date lines.

https://app.powerbi.com/groups/me/reports/ca0375eb-c1dc-47a8-b8a8-833647586f02?ctid=f2cd9782-65e5-45... 

Hope the link is working

I don´t know what to do.

Any help will be welcome.

Cheers

[mahoneypat · Accepted solution]

Your date column is actually in datetime format, so it won't make a good relationship with your Date table.  In the query editor, change that column to just Date format.

Regards,

Pat

[SMOYAMI]

Superthanks

[SMOYAMI]

Sorry but i don´t know how to attach the pbix, anyway you can see it in this new onedrive link.

https://1drv.ms/u/s!AsWx8pso9cwO4UDIYiKzClnZ8ebE?e=s807Xr

Thanks a lot

[amitchandak]

@SMOYAMI , We are not able access the app.

There can few reason. Is date in slicer and in table are same or rate from different table,

If from different are they joined

If from same table are they interacting

If interacting are you using all, allselected or allexcept in you measure ?

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.