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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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
Helper III
Helper III

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
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.