Showing actuals and forecasts in the same chart with Power BI
The data model used for this example contains two tables: Sales and Budget. The two tables are linked to Customer, Date, and Product through a set of relationships. They are strong relationships for the Sales table, which contains information at the key granularity; and weak relationships for the Budget table, which must be linked to the three dimensions at a different granularity.