Change Slicer values automatically every Week

Question

Hi all, I have a total of 8 slicers in 4 bookmarks. This is what it looks like. For example, this Monthly bookmark has 1 slicer for 'Earlier Period', and another slicer for 'Latest Period'. Both slicers are referencing different fact tables. I tried using DAX to use just one fact table or date table, but certain data would be left out. This solution works for now.My data compares last w/m/q/y to previous w/m/q/y. So the 'Earliest Period' should be automatically on 2 weeks/m/q/y ago, and 'Latest Period' should be last week/m/q/y. I would like the slicer values to change automatically every week to the correct 'Earliest Period' and 'Latest Period'.&nbsp;Right now, I'm updating the slicers manually every Friday. I would like this to be done automatically.&nbsp;Why am I using slicers? Because the user should also be able to change which weeks/months/quarters/years to compare.&nbsp;Anyone knows what to do?

uzi2019 · Accepted Answer

Hi&nbsp;VisualJade&nbsp;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.
&nbsp;
for example today 's month is 4. If&nbsp; 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.
&nbsp;
See for example I have created Previous Month dax to calculate Feb data .

&nbsp;
If I put this in slicer visual filter like this

&nbsp;
&nbsp;
So it is just having Feb month not other data. users wil not be able to change the selection bcz there is no data.
&nbsp;
So solution you are looking that automatically data should be selected based on latest refresh is not quite possible.&nbsp;
&nbsp;
I hope I answered your question!
&nbsp;
&nbsp;

Forum Discussion

Related content

Monthly Automatic Change

Date between slicer - Change order

Black slicer apper when change Visual

Automatics Refresh

Automatic Selection in Slicer ?