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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
arnaud_priere
New Member

Setting a date slicer range

Hi,

 

At the moment I have this kind of basic date slicer 

arnaud_priere_0-1634657278975.png

I'd like it to be set by default to the current trimester(current quarter of the year)
If the current date is 19/10/2021 then the current quarter of the year is the 4th, so the date would go between
the 01/10/2021 and the 30/12/2021, like this :

arnaud_priere_3-1634657457162.png

My way to do it would be to get the current date, looking for which quarter of the year it belongs to, then pre-setting it to this slicer, when people get on this report, the date range would be like on the screenshot by default.

 

I'm thinking of using a measure, but I really don't get how to implement this, 

 

Thanks a lot

 

 

 



 

2 REPLIES 2
v-luwang-msft
Community Support
Community Support

Hi @arnaud_priere ,

In my opinion, this cannot be achieve.

 

Best Regards

Lucien

YukiK
Impactful Individual
Impactful Individual

You can change your slicer format to "Relative" (click on the dropdown arrow on the right upper corner of the visual) and set it to show last year, month, etc.

 

Hope that helps!

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.