Power Bi Visual Connceting Dates of two different tables

[MontanaBlack]

Dear All,

I try to connect in a "Line and stacked column chart" a Forecast line in the field line Y-Achse. The dataset is based on 1 table with a date column and the Forecast values are based on another table with date line format. If I put under X-Achse the month from table A  and under Y-Achse the values for bookings from the same table I get the respective Chart. But if I add under Y-Line the values from Chart B for the Forecast Values BI sums all values from this table fom Jan- to Dec and shows one line for each month with the sumed value for the year, but I want to have for each single month of table A the Forecast value in the y-line. It seems, that BI is not abele to connect the date of both tables. What can I do? 

Thanks in advance.

Kind regards,

[Deku · Accepted solution]

• Create a date table with CALANDARAUTO()
• Right click on the table and mark it as a date table
• create a 1 many relationships from dates[date] to actual and forecast tables
• Add date[date] to the x axis

[MontanaBlack]

Thanks a lot. It works...

[lbendlin]

You can provide meaningful sample data.

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.

Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...