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

View all the Fabric Data Days sessions on demand. View schedule

Reply
Peter12
New Member

Multiple Filters on multiple tables

Hi, 

I have the below scenario where I have a forecast table and an actuals table. I would like to present "forecsat hours" and "actual hours" on a chart visual with the week ending on the X axis. I would like the data to be filtered by location, project name and week ending using slicers. Any help would be much appreicated. Thanks

Peter12_0-1676677391585.png

 

 

2 REPLIES 2
PawelWrona
Resolver II
Resolver II

Hello, what is your expected solution here? In which area you need help?

Sorry, I can't seem to get the visual to look how i want it to. If i set the relationships for each of the three filters (location, project, date) to the forecast & actual tables I get errors.  I can get one set of data on the visual, but then when i add the other its not filtered by location or project. Does that make sense?

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