Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Dynamic Slicer

I have a slicer called month year which is set to Aug 2018. so when i publish it to server, the default view of the page would be the visuals showing for Aug 2018. However, in Sept 2018, i would like...
Need Help
v-frfei-msft's avatar
v-frfei-msft
Community Support
7 years ago

Hi Anonymous,

 

We can create a calcualted column to work on that.

 

Column = 
var yearc = YEAR(Table1[date])
var monthc= MONTH(Table1[date])
var yeart = YEAR(TODAY())
var montht = MONTH(TODAY())
return
IF(yearc=yeart && monthc=montht, "the last month",yearc & FORMAT(Table1[date],"mmm"))

 

For more details, please check the pbix as attached.

 

Regards,

Frank

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    v-frfei-msft Hey this would just filter my slicer for one month then and my users will not be able to see the other dates.

     

    Now i have the month year slicer set to Aug 2018 and all my visuals on the page are filtered for that. But once i move to october, this month year needs to be September 2018 (On october 4th this needs to change when data refresh happens). But since the page is set to aug 2018 that becomes the default.

     

    I want to make this process automated though. So if there is any way to set the page as of the previous month year (On the 4th of the present month) then it would be great! Maybe not neccesarily by using slicers, but any other method.