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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
aar1
Regular Visitor

Set Default Value of Quarter Slicer to Current Quarter

I have a column in a table called 'submission date' and using the date hierarchy I have added a 'filter by quarter' slicer. I want the slicer to have a default selection of the current quarter but if the user selects other quarters then the visuals should filter accordingly. Is there a way to do this?

aar1_0-1687190888293.png

 

1 REPLY 1
amitchandak
Super User
Super User

@aar1 , As of now you have to use a workaround

 

A new column like this and save on this Qtr

 

Switch( True() ,

format(today(), "YYYY - \QQ") = format([Date], "YYYY - \QQ"), "This Qtr",

[Qtr Year]

)

 

Default Date Today/ This Month / This Year: https://www.youtube.com/watch?v=hfn05preQYA

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

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.