Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi all,
I have 2 filters in my report, one that shows the months and one that shows the quarters.
Now when I click on for example February, my 'quarterly' filter is automatically changing to Q1. I understand the logic, but now I would like to play a little bit with the filters and what I actually want to achieve is that I when I click on February, I would see all 'quarterly' filter buttons (Q1,Q2,Q3) instead of only QTR 1. If however afterwards I would click on a specific QTR, for example QTR 2, it would anyway need to filter/highlight April, May and June (and having all other months still visible in the filter).
Is it correct understanding that I could achieve this via bookmarks?
Thanks for any guidance 🙂
Regards
Solved! Go to Solution.
Yes, you need to duplicate your current sheet to 4 sheets. Each sheet will fixed filter with different quarter filters Q1, Q2, Q3, Q4. Then bookmark each of them with the different names
Now you can create 4 quarter buttons then assign to above bookmarks 🙂
Thanks Linh for the advice 🙂 Much appreciated
Yes, you need to duplicate your current sheet to 4 sheets. Each sheet will fixed filter with different quarter filters Q1, Q2, Q3, Q4. Then bookmark each of them with the different names
Now you can create 4 quarter buttons then assign to above bookmarks 🙂
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
71 | |
70 | |
43 | |
31 | |
26 |
User | Count |
---|---|
89 | |
49 | |
44 | |
38 | |
37 |