Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
Hi.
I'm working on a report.
The user chooses week to display on a slicer
Data is groupped by weeks. There 2 types of diagrams:
1) Data should be displayed for the week chosen in slicer
2) Data should be displayed for the week chosen in slicer plus 5 previous. I don't know how to do id. Pleas, help
2) You write a measure that changes the date filter to include the current and previous five weeks. This assumes that you have a calendar table in your data model and that this table has a week number column. You will want to define what should happen at the beginning of the year.
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!