Forum Discussion

MontanaBlack's avatar
MontanaBlack
New Member
1 year ago
Solved

Power Bi Visual Connceting Dates of two different tables

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 ...
  • Deku's avatar
    Deku
    1 year ago
    • 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
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
1 year ago

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