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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Show last quarter complete quarter on filters when opening the report in Power BI Service

Hello,

 

I have date table with the filters: YEAR and Quarter (this table also has offset quarters, years and etc)

By default I want the filters to be always the latest Quarter complete (e.g 2021 - Q1) when open the report in Power BI Service.

 

I thought about using bookmark but I couldn't make that work properly as the bookmark i kind of hardcode the current quarter but and for the next quarter?

 

Any Ideas?

 

Thanks!

 

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@Anonymous ,

Create a new column like

 

Switch( True() ,

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

[Qtr Year]

)

 

And save on This Qtr

 

or

 

Switch( True() ,

format(today(), "YYYY - " ) & "Q" & format(today(), "Q") = [Qtr Year] , "This Qtr",

[Qtr Year]

)

 

Try like

Default Date Today/ This Month / This Year: https://www.youtube.com/watch?v=hfn05preQYA&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=35

View solution in original post

1 REPLY 1
amitchandak
Super User
Super User

@Anonymous ,

Create a new column like

 

Switch( True() ,

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

[Qtr Year]

)

 

And save on This Qtr

 

or

 

Switch( True() ,

format(today(), "YYYY - " ) & "Q" & format(today(), "Q") = [Qtr Year] , "This Qtr",

[Qtr Year]

)

 

Try like

Default Date Today/ This Month / This Year: https://www.youtube.com/watch?v=hfn05preQYA&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=35

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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