Forecasted Values vs Actuals (Clustered Column Chart)

[specs129]

Hi All,

New to PowerBI and so you can say this is my crash course. Anyways, I have managed to create a visual for what my forecasted values where:

Now I would like to bring in the actuals sales quantities from another table, but when I do I get the following:

Am I missing a relationship or something else? Please reach out if there is any further info. that is needed to help me with this.

Thanks

[Ashish_Mathur]

Hi,

Share the link from where i can download your PBI file.

[VahidDM]

Hi @specs129 

It seems you missed the relationship, and because of that in the chart, it shows the total value of actual sales quantities.

The best solution is to add a date/calendar table to your model and connect those two tables to the calendar table.

see this link to create a calendar/date table:

https://www.vahiddm.com/post/creating-calendar-table-with-3-steps

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

Appreciate your Kudos!!