Forum Discussion
Change Slicer values automatically every Week
- 2 years ago
Hi VisualJade
If you would apply a pre filter to a slicer then only calculated data will be appear on slicer value. user will not be able to modify any other date.for example today 's month is 4. If I create a column that only calcultes earlier month ie Feb based on todays date. then slicer will not show the rest of the data. after applying the filter to the slicer.
See for example I have created Previous Month dax to calculate Feb data .
If I put this in slicer visual filter like this
So it is just having Feb month not other data. users wil not be able to change the selection bcz there is no data.
So solution you are looking that automatically data should be selected based on latest refresh is not quite possible.
I hope I answered your question!
Hi VisualJade
If you would apply a pre filter to a slicer then only calculated data will be appear on slicer value. user will not be able to modify any other date.
for example today 's month is 4. If I create a column that only calcultes earlier month ie Feb based on todays date. then slicer will not show the rest of the data. after applying the filter to the slicer.
See for example I have created Previous Month dax to calculate Feb data .
If I put this in slicer visual filter like this
So it is just having Feb month not other data. users wil not be able to change the selection bcz there is no data.
So solution you are looking that automatically data should be selected based on latest refresh is not quite possible.
I hope I answered your question!