Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Table visualization left outer join without creating a custom query

I'm creating a table visualization based on two tables in my data model; site (containing location information) and entity_phone (containing phone numbers, but not only for sites but also for persons...
Need Help
  • v-yingjl's avatar
    v-yingjl
    6 years ago

    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 Li

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

v-yingjl's avatar
v-yingjl
Community Support
6 years ago

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 Li

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

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Updating the bookmark was where I went wrong, just recently started using Power BI, thank you 🙂