Plot data from two tables using the same Dates

[gundam_pilot]

Hi all

I have two tables with different data. Both have a end of month Date field (although by different names).

I would like to plot data from the two tables on the same plot, with the x-axis using the same dates, how do I establish this relationship or let Power BI know that the two dates are the same and plots/data can be shared?

[v-diye-msft · Accepted solution]

Hi @gundam_pilot 

You can create the relationship by:

1. On the Home tab, click Manage Relationships > AutoDetect.

2. Create a relationship manually. draw a line from the date column in the first table to the second table:

Then create the visual using date as x-axis:

[venal]

@gundam_pilot 

Create a relationship for the common column from Home >> Manage Relationships.

Now use the date column in X-axis and measures in Y-axis.

If this post helps, then please consider Accept it as the solution to help the other members find it more

If this post was helpful may I ask you to mark it as solution and give it some kudos?