Displaying Null values in relationship

[aishak12]

All, 

I have two tables

Table 1

Location

Table 2 

Location, Value, 

Now I want to create a table matrix that includes ALL locations in Table 1 + Table 2. 

If table 2 does not have a location to match table 1. The row should look like this.

Location1               Location2                Value

New York                 (blank)                  (blank) 

I created a Many to Many relationship but this is not showing NULL values. 

[amitchandak · Accepted solution]

@aishak12 , left join in Power query merge 

 https://radacad.com/append-vs-merge-in-power-bi-and-power-query

Natural left join in DAX

https://www.sqlbi.com/articles/from-sql-to-dax-joining-tables/

Join A and B, plot data from both in visual with this option on the column on A