100% Stacked Bar Chart - Multiple Table issues

[Anonymous]

I'm trying to create a 100% stacked bar chart using 3 columns across 2 different tables - 1 for the Y-axis, 1 for the X-axis and 1 for the Legend.

These 2 tables and values are indirectly linked through a common attribute(column) in a 3rd table. Think:    Table 1 - Table X - Table 2

One of the columns consists of lengths, which would be used for the X-Axis. For some reason I'm getting equal summed values for each of the legend value, as below. I'd like to make it look like the visual below it. 

[amitchandak]

@Anonymous , The year/legend. This means the y-axis column and legend should come from common tables

If you trying create measure across table, where one table have some data , you need make sure your measure get filtered based on another table

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.