Instead of using a filter, you can use a date parameter. Then, insert the dates from the Day_Nbr field. From here, a calculated field will be created that looks similar to the following:
if [Date Parameter]=dateadd('day', 1, [Date Field]) then [Date Field] end
Then, place this on the filter shelf, and check the Exclude box and Null. Finally, right click on the parameter and select Show Parameter Control.
Hope this helps! Let me know if I've misunderstood the issue.
I have attached one excel file to explain the requirement. My requirement is that I need to display value of the metric for the date(filter) selected by user and I am able to do this. With this I also need to display Previous day value of the metric along with selected date value and I am not able to achieve this.
I am able to get Previous date by creating a calculated field with expression "max([FACT_Abc_DAY_NBR])-1" but not sure how to use this to get the metric value for this date.
Thanks a lot for your help.