Default selection in a slicer equal to current month

[Anonymous]

Hi everyone,
I have a report with a date slicer that has the month column in it. For reporting reasons the current month must always be selected, by default. As of now I am changing the month in the filter each 1st of the month. For example, tomorrow morning I will change the month selected to May and publish the report in the service again. However, I would like to automate this operation. 

Is there a way to do it? I tried solving it with a calculated column that identifies the current month and then applying this filter to the slicer but in this way I filter out all other months, and they must be available for selection. 

Thanks

[v-kelly-msft · Accepted solution]

Hi @Anonymous ,

Pls refer to the below post:

https://businessintelligist.com/2016/04/15/power-bi-tutorial-dynamically-update-date-slicer-to-show-current-date/

https://community.powerbi.com/t5/Desktop/Setting-the-Default-Value-of-a-Slicer/td-p/16442

 
Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[mitsu]

Couple of options here . 

1> Use the date instead of month . The relative date filter as This month . 

2> What we do is mark the current month with a suffix current on the date dimesion dynamically using SQL . That way on the report you can filter by the month that contains the suffx Current .

Thanks,

Mitsu

[amitchandak]

@Anonymous ,

You can use relative date slicer

https://docs.microsoft.com/en-us/power-bi/visuals/desktop-slicer-filter-date-range

Or you can create a column like this in you date table

If (format([date],"YYYYMM")=format(today(),"YYYYMM"),"Current Month",format([date],"MM-YYYY"))

And use that in filter