Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
SJim
Frequent Visitor

Select current date as default selection in slicers. (Tabular model - Report Server)

Hello,

 

So I have a 'Year' slicer and a 'Month' slicer, I want my end-users to enter the report with the current Year and Month selected. How to achieve this? I know its possible in Power BI desktop but notice that I am having this problem with Tabular model + Report Server.

 

Thanks in advance,

Jim 

2 REPLIES 2
RobThrive
Resolver I
Resolver I

How can you do it in desktop please?

The closest thing I'm using right now, is the relative date option on the slicer which allows you to select "the last X days/weeks/months" from todays date.

I cannot give you the perfect answer but take a look at these workarounds: 

 

Solution 1:

https://community.powerbi.com/t5/Desktop/How-to-show-set-slicer-to-current-month/td-p/83302

 

Solution 2: 

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

 

Good luck 🙂 @RobThrive 

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

Check out the February 2025 Power BI update to learn about new features.

Feb2025 NL Carousel

Fabric Community Update - February 2025

Find out what's new and trending in the Fabric community.