The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
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?
User | Count |
---|---|
60 | |
55 | |
53 | |
49 | |
30 |
User | Count |
---|---|
179 | |
87 | |
70 | |
48 | |
45 |