Forum Discussion

sivashankr's avatar
sivashankr
Helper II
6 years ago
Solved

LEFT OUTER JOIN in Modelling (Not Merging or DAX)

Hello Team,   By SQL looks like below. Could you let me know how to mimic the same in Power BI Modelling. I tried with One-Many/Many-Many everything works as same as INNER JOIN.    Note: I can't ...
Need Help
  • v-xuding-msft's avatar
    v-xuding-msft
    6 years ago

    Hi sivashankr ,

     

    If there are blank values in visuals, they will be hided by default. It is by design for Power BI. So, after creating relationships, you need to turn on the option "Show items with no data". 

    For you situation, you could turn it on and re-publish the reports to users. Then the report will working fine. Users don't need to turn on again by themselves.

     

     

    change the cross filter direction from both to single

     

    Show items with no data

     

     

sivashankr's avatar
sivashankr
Helper II
6 years ago

Hello ibarrau 

 

Thanks much for looking into this.

Originally, I created a dataset (model) and published to Service for user self-service reporting.

When I asked the users to turn-it on "Show items with no data", they questioned me "Can't we create a LOJ to pull all therecords from left table using Modelling window?"

 

So request you please let me know if there is anythng that we can do in Modeling window itself.?

v-xuding-msft's avatar
v-xuding-msft
Community Support
6 years ago

Hi sivashankr ,

 

If there are blank values in visuals, they will be hided by default. It is by design for Power BI. So, after creating relationships, you need to turn on the option "Show items with no data". 

For you situation, you could turn it on and re-publish the reports to users. Then the report will working fine. Users don't need to turn on again by themselves.

 

 

change the cross filter direction from both to single

 

Show items with no data