I have a date column, which I need to use as Slicer using 'between' setting. If I use the same column in a dropdown it shows me blanks but in slider it by default removing blanks. so I choose blank and any desired date range example 12/31/2018, gives me same count as excel. but when I use in between date slider, it excludes blanks.
why I need blanks, it's affecting my count, since Power BI removes blanks line by line so I am losing the lines which have values in other columns. please suggest. the user really needs slider as the date range is huge.