I have two tables
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.
Go to Solution.
@aishak12 , left join in Power query merge
Natural left join in DAX
Join A and B, plot data from both in visual with this option on the column on A
View solution in original post
Check out the changes to the Power BI Community announced at Build.
Find out more about the May 2023 update.
Visit our Data Stories Gallery and give kudos to your favorite Data Stories.