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!View all the Fabric Data Days sessions on demand. View schedule
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
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?
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!