Forum Discussion
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
2 Replies
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?
