i have below requirment and facing an issue, can you please check and let me know the resolution
1. I have a Slicer with dates, when the report loads by defualt the Slicer value is ALL (i.e.,i am not going to select any date from the slicer dropdown) then i want to show last 10 days data. If there is no data from the last 10 days the data in visuals should be NA.Dates
2. If i select any date from Slicer it should show the respective date data.
I was able to get the last 10 days data by using below formula in calcualted column
Thank you for the reponse, i am able to see last 10 days data by applying the filter using the calculated column, but i want to see other dates also not only the last10 days in slicer.
my requirement is mentioning again below please let me know for any other questions.
1. When ever the report loads, by defualt it should show the last 10 days data without selecting any date from slicer.
2. If user select any specific date from slicer(it should contains all the available dates not only the last 10 days dates) it should show the respective date data.
to achive this i am facing following issue.
using calculated column i am able to filter the last 10 days data and able to show the data in visual, but becuase of this filter i am not able to see other dates which are above to last 10 days. i want to see all the availble dates in Slicer and based on slicer selection it should show the data as well in visuals.