Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
gladerkate
New Member

Partially filter my table visual with a slicer

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! 

1 REPLY 1
johnt75
Super User
Super User

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.

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors