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
Hello community!
mum relitively new to Power BI and data anylitics and am having issues (probably around the logic) with this problem.
I have a matrix table that has Customer name (from my customer table) as the column, and Month (from my date table) as the row. The values are all then counts of jobs, sales, etc from my job analysis table.
I've related my customer list to my job list by customer name and date in my date table to job date in my job analysis table. I need a way to be able to filter my customers by customer created date (from customer table) but still show all months jobs for those select customers? At the moment, it's filtering to just the selected month, but also only shows jobs, sales, etc. from that selected month.
Any advice would be fantastic. Thanks!
Create a copy of your date table and link that to your customer created date. Use columns from this new date table in slicers and that will filter to just those customers created in the selected date range but will still show the jobs etc for the dates from your original date table, as it does now.
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!