March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
Register NowGet certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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!
Solved! Go to 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
@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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
Check out the November 2024 Power BI update to learn about new features.
User | Count |
---|---|
116 | |
88 | |
78 | |
65 | |
59 |
User | Count |
---|---|
140 | |
122 | |
105 | |
94 | |
90 |