Forum Discussion
Fill in Missing Dates for Multiple Rows
Hi all, I've got a dataset that has four variables that serve as slicers (location, employee type, status1, and status2) by date. Our data system does not create rows for days with zero reports, ...
Thank you. I tried the measure as suggested and it does not seem to work if any of the slicers are used. If no slicers values are selected, the zero dates appear fine. But when I click on a slicer value, the zero count days disappear, since there is nothing in the zero day data row to correspond to the slicer values of location, type, etc. values being filtered on.
Anonymous - It sounds like you might want to be using a disconnected table for your slicer. If you do that, then you have much more control over what gets displayed and what does not get displayed.