How to include blank fields when a table is filtered by a Date?

[GeorgeG]

Hi Everyone,

I currently have a table with two columns and a serparate slicer the the date. The first column is a list of clients and the second column is the date they last made a payment.

I can use the slicer to show, for example, 2020 so far. When I do this, I see when the last time each Client made a payment this year. 

However, I would like to include the Clients that have not paid, and simply return a blank field. So when 2020 is selected, it will also show the Clients that have not paid. Can anyone help me with this? Happy to provide any additional information needed, thank you.

[v-eachen-msft]

Hi @GeorgeG ,

Could you please share your sample data here if you don't have any Confidential Information? Please upload your files to OneDrive for Business and share the link here.