We have used 3 Excel Tables to create this dashboard using Power Pivot
In this table, we have 3 columns – Month, ProductID, and Budgeted Amt
2.Product Master Table:
In the Product Master table we have 3 columns – ProductId, Product Name, and Category.
In this Table, We have 3 columns – Date, ProductId, and Sale Amount
Below is the Data Model diagram for this dashboard:
We have used the below 5 measures for this dashboard using DAX.