Return Previous dates with zero count values.

[Tanushree_Kapse]

Hi All,

Here is the data and the date slicer which I have :

Now, when I slide the slicer from left to right, I must also get the previous dates for which the Measure is 0.

For example: when the slicer is sliced from 8 Jan to 31st Jan, I should also get the dates before 8th Jan for which the Measure is 0: (1,2,3 nd 7 jan).

Please help!

[wdx223_Daniel]

maybe you need two date table, one is on the row, another is on the slicer

[Tanushree_Kapse]

@wdx223_Daniel , Ok...but then how do I filter the table visual as required.

[wdx223_Daniel · Accepted solution]