Forum Discussion
Table visualization left outer join without creating a custom query
Hi Anonymous ,
1. Based on your description, if you don't want to show the rows which site_no column is not blank, you can set a filter on this page like this:
Don't forget to right click the bookmark to update it after setting filters so that the bookmark status will not reset.
2. Whenever we create a relationship, Power BI implment INNER JOIN by default. If you want to get a left outer join, you can try to use NATURALLEFTOUTERJOIN() function. Refer this issue: left outer join with out creating new query or table. is any DAX query
Best Regards,
Yingjie LiIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Too many words.
Can you give us sample data for the two tables - and tell us if there is a relationship between them .
Also show us the desired output.
Someone will answer you.
Sure, these are the values in the table:
With site information coming from the site table and phone_number coming from the entity_phone table (as well as some other fields coming from other tables).
And this is how it currently appears:
Many phone numbers have no associated site, but still appear in the table, which I would like to get rid off.
Because the primary key in the table is not unique (in the SQL database it is part of a compound key) I've created a compound key in Power BI which I use to link the two tables:
If you need additional information let me know. Thank you for your help 🙂