Automating the Slicer visual consists of Months of a year to select the current month

[v-agutta]

Hello everyone,

We are using slicer visual where it is having Months of a year. We are supposed to change the Month whenever month changes. We need to automate the process like it should be automatically select the current month whenever there is month change and it should display the current month data.

Thanks in advance!!!

[v-rongtiep-msft · Accepted solution]

Hi @v-agutta ,

We can achieve this requirement by using a workaround. We can create a column which can have same value but get updated in the background based on current Month.

Current Month=If(year(column)=year(now())&&month(date)=month(now()),"Current month",Month(date))

You can use this DAX to create a column value "Current Month" and gets updated whenever the month change no need to do any external work.But there is no possibility to get current month name directly to the value and make it selected by default as the month names changes every month.

Please refer to the video to see if it helps you.

Set Default Slicer Value to Current Month in Power BI 

Or maybe you can vote here. Set date slicers to current date 

Best Regards

Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[mohammedadnant]

Hi @v-agutta 

Please refer to these 2 videos, they will help you to get the logic, of how this works

https://youtu.be/wFNzlVl51Zw

https://youtu.be/KAOsHC2zitI

If this is the answer to your query, please hit the like button. 

Thanks & Regards,

Mohammed Adnan

Learn Power BI: https://www.youtube.com/c/taik18