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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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