In date column, column selected a date range and "blank" date together?

[rickylee]

Hello,

I have created a visualisation based on date. It shows the number of customers within the date range. However, I realised some customers do not have a date range and would like to include them. 

I tried to create two slicers but the one with date range dominated the one which "blank". It seems I cannot select customers in a date range and also the data column is 'blank' in one go.



Any ideas?

Thanks,
Ricky

[petrovnikitamai]

i'm not shure but try

one way

1. add new column and write instead blank some date, for example

date_corrected = IF(ISBLANK([date]);DATE(2018;06;01);[date])

2. use in slicer this column or get relationship with dimdate

other way

create second table with customers(blank date) only and remove interaction with date slicer using