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.
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
Last10daysCalcolumn = if(NOW() - 'Table3 (2)'[Date] <= 10 && 'Table3 (2)'[Date] <= NOW(),1,0)
now my issue is using above calculated forumla i got the results as 1 or 0.
i am using Last10daysCalcolumn settingthe visual level filter to existing visuals in report for either 1 or 0 not able to do else condition.
Can you please help me achive this requirment or any other suggest me do i need to follow any other method to achive this.
Based on my test, you could use the Page level filters function:
Use the Page level filters function:
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.
Could you please offer me a sample data to have a test?