topic Re: Power Bi Visual Connceting Dates of two different tables in Custom Visuals Development Discussion

Power Bi Visual Connceting Dates of two different tables

MontanaBlack — Fri, 14 Mar 2025 13:29:39 GMT

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,

Re: Power Bi Visual Connceting Dates of two different tables

lbendlin — Sat, 15 Mar 2025 00:16:35 GMT

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-Forum/ba-p/963216
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

Re: Power Bi Visual Connceting Dates of two different tables

Deku — Sat, 15 Mar 2025 12:21:26 GMT

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

Re: Power Bi Visual Connceting Dates of two different tables

MontanaBlack — Thu, 20 Mar 2025 09:57:40 GMT

Thanks a lot. It works...