Budget vs Actuals Data Mapping

[arafmustavi]

Hi,
I have been trying to develop a model in Power BI. I have two Table. The Headers for the Two Table

Table 01 [Target] :

Category

Month

Target

Table 02 [Sales] :

Category

Date

Sales

I am trying to find out the process by which I can play around my slicers and then the Budget vs Expenditure will be shown in a Bar Graph. Can anyone tell me what is the efficient way to do this?

[Anonymous · Accepted solution]

Hi @arafmustavi ,

You will need at least a column in both tables to relate the two tables, I'm not sure if it is [category] column.

Then you just need to create a relationship between these two tables.

Best Regards,

Jay