Display records that dont match with date slicer

[PBI5851]

Hi,

I have an interesting request, where in the raw data as below, there are members with open date and close date populated and members with just open date. Now i must have a slicer for close date , but when i add that , the records with no close date dont appear. How to fix this issue. I cannot use "edit interaction" as there are other visuals dependent on this slicer. 

Name	Open Date	Close Date	Status
John	1/1/22	2/1/22	Complete
Smith	1/5/22		Pending
mary	1/10/22	2/2/22	Complete
Eve	1/5/22	5/3/22	Complete
Turner	1/10/22		Shipped

The end visual is summary and detail of these individuals, but the members with no close date dont show due to close date slicer. Any recommendation on how to resolve this. 

[FreemanZ · Accepted solution]

do you have a Date table? try to pull the date column from the Date table?

[vicky_]

You could try right click on "Names" and make sure that "Show Items with no Data" is checked.