Forum Discussion
Include empty date values in table when changing date slider
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.
Hi some_bih : I have set the data types as in the report. Blank dates are visible only when the left side of the slider is unchanged and right side slider is changed.
We would like to see blank records when right or left slider is changed by user.
Inital View when the slider is unchanged:
View when right side slider is changed, We get blank dates as well:
View when left side slider is changed, blank values are disappeared