Make the current month as default value

Anonymous , You have to create a date table and join it with all three tables on date.

Then you need to have month year and this column in date column

 

Month Year = FORMAT([Date],"mmm-yyyy")
Month Year sort = FORMAT([Date],"yyyymm")

Month Type = Switch( True(),
Date([Date]) = eomonth(Today(),-1),"Last Month" , //Last Month
Date([Date])= eomonth(Today(),0),"This Month" , //This Month
[Month Year]
)

 

Sort both month year and month type on month year sort. Take slicer on Month Type, select current month and save

https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column

Dafault Date/Month

https://www.youtube.com/watch?v=hfn05preQYA

Hi Anonymous ,

 

You can achieve this by using hasonvalue and filter where you will compare your max month to the moth of today

 

Hope this helps. Thanks

Hi Anonymous,

Unfortablely, current power bi does not support setting default value on the slicer.

For your scenario, I'd like to suggest you create a calendar table to link your table date fields. Then you can add a calculated column with if statement to check date value and return tag.  After these steps, you can use this tag to choose current month and save to bookmark to quick reset slicer to the 'default value' current month.

Regards,

Xiaoxin Sheng