Forum Discussion
Solved
Dynamic actual vs forecast?
Hi, I have unpivoted my data using SQL and loaded my tables into my PBI report like the below. What I want to be able to do is based on the slicer selection, I want to see the total expect...
You could append your tables together like this:
Key Amount Date Type 419660 476.28 23/05/2022 Expected 419660 934.92 22/05/2024 Expected 419660 352.8 02/05/2025 Expected 419660 119.76 08/03/2023 Actual Then use the Type as your legend in the chart.
You could append your tables together like this:
| Key | Amount | Date | Type |
| 419660 | 476.28 | 23/05/2022 | Expected |
| 419660 | 934.92 | 22/05/2024 | Expected |
| 419660 | 352.8 | 02/05/2025 | Expected |
| 419660 | 119.76 | 08/03/2023 | Actual |
Then use the Type as your legend in the chart.