Forum Discussion
LEFT OUTER JOIN in Modelling (Not Merging or DAX)
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
Hello there, I am facing the same issue when I try to use a matrix visual. The visual shows the data for columns which both the joined(Relationship modeled) tables has data for. But not for columns in which only one table(Left table) has data for. Does the solution proposed by you work for matrix visual as well?
Hi, I think this is by design per the doco here: https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-show-items-no-data#how-show-items-with-no-data-works
Particularly this part:
"It's important to note that the mechanism of selecting values for the columns is order-dependent, and can be thought of as a Left outer join operation between tables. If the order of the columns is changed, the results change as well."
Even if you have 'Show Items with no data' turned on, it will still hide data in columns for rows with no data on one side of the join if you don't have the columns in the right order in the table or matrix. Putting the columns from the fact table where there is data on the left side and together will mean that the data will show. If any columns from the empty table are in before that, then the data afterwards on the right won't show.
I'm trying hard to find a way around it as it makes using PowerBI models with multiple fact tables as a data source for live-connect reporting very difficult. Having to explain to end users to properly understand the join and put columns in the right order - or just to remember that myself every time will be a pain. Let me know if you find a way