Forum Discussion
Include empty date values in table when changing date slider
Hi All, I have a field called "NEXT_REVIEW_DATE" which is of date datatype. I am using this field as a range slicer. There are few records with empty date value for "NEXT_REVIEW_DATE" . Wh...
Hi poojithas I inserted into Excel your data and impor into Power BI.
During transformation in Power Query I choose data type for dates columns as : type date. Result is visible below. In table visual when I change date period, dates from period AND Blanks are visible.
Please try to change your data type to type date and check interaction with slicer. I hope this help.