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

Question

Hello,&nbsp;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.&nbsp;Thanks in advance,Jim&nbsp;

robthrive · Answer

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.

sjim · Answer

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

Forum Discussion

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

2 Replies

Related content

Selected slicer

Slicer default selection

Single select slicer

Between date slicer - calender selection

Slicer Clear Selection White