Forum Discussion
default Slicer
We have 4 years of data i.e from the past three years and a year of future data. we need to add a slider slicer to the date field. The slicer should be selected default for the current month (MTD) i...
ValtteriN
Community Champion
Community ChampionHi,
Here is one way to do this:
Add this column to your calendar:
This Month =
var TW = DATEDIFF(TODAY(),'Calendar'[Date],MONTH)
return
If(TW=0,"Current Month",'Calendar'[Month]
)
Then use that as a slicer:
My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/
Then use that as a slicer:
I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!
My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/