Automatically to select the new month in the slicer visual

[v-agutta]

Hello everyone, We are having a power BI report where we will display the data across the month level. Whenever a month changes, for example from May 22 to June 22 it should automatically show only June 22 data. Currently we are doing manual activity to select the new month whenever month changes and publishing the report. Is there any way that the slicer visual automatically select the new month when month changes? Thanks in advance!!!

[Anonymous]

Hi @v-agutta,

Current power bi does not support the setting default value of the slicer.
I'd like to suggest you create a calculated column to check the date range return tag and filter based on the tag or use a slicer with relative date mode.
After these steps, you can use this on the slicer to filter records, they will update when table records and system date changes.
Regards,

Xiaoxin Sheng

[tackytechtom]

Hi @v-agutta ,

You could set a filter in the filter pane like this:

Note, Custom is the name of my date column.

Does this solve your issue? 🙂

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/

[v-agutta]

Hi @tackytechtom ,

Here is the below screenshot for the reference of our slicer visual.

So our target is now when a month in any of the quarters changes then the new month checkbox should be selected. The remaining should not be selected. 

And i m not able to see the Filter type in my PBI desktop application

Could you please give any alternate solution?

[tackytechtom]

Hi @v-agutta ,

I think, I now understood your problem. You still want to give the ability to the end users to change values afterwards. 

How about this?

Set Default Slicer Value to Current Month in Power BI - Gorilla BI

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/