Forum Discussion

VisualJade's avatar
VisualJade
Frequent Visitor
2 years ago
Solved

Change Slicer values automatically every Week

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 slic...
  • Uzi2019's avatar
    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!