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

[Anonymous]

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!

[amitchandak · Accepted solution]

@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