Table with Date slicer, with blank dates included

[Michie_24]

Hi, I am struggling with this scenario.

I have a table with activity and date column (Table 1). 

I would like to count the activity per date and show it in a table. I need a date slicer that can filter the dates in the table, but at the same time also show the activities with blank dates (Table 2). 

Thank you. 

[Ahmedx]

pls try this

Date slicer.pbix

[Syndicate_Admin]

try this

https://1drv.ms/u/s!AiUZ0Ws7G26Rii2fTZOp0NwtfEBN?e=HL9p57

[Ahmedx · Accepted solution]

Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.

https://1drv.ms/u/s!AiUZ0Ws7G26Riiw4Gf9TrOC6IO5h?e=6tjYad

[Michie_24]

Hi @Ahmedx , 

I am not able to view the pbix file. There might be some permission restrictions.