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

     

     

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