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
sivashankr , not very clear.
But in power bi default is right join 1-M. If you add +0 to measure and view with 1 side of table it will become left join
measure = sum(TABLE2[value])
view by Table1[Col1]
others are
https://www.sqlbi.com/articles/from-sql-to-dax-joining-tables/
https://radacad.com/append-vs-merge-in-power-bi-and-power-query
Hi amitchandak ,
Thanks much for the reply.
Here is my sample data set for 2 tables and actual output vs expected output.
I created Many-1 or 1-Many by interchanging the tables. But I still see the below output which is same as INNER JOIN.
I would like to see the highlighted records also in my output. Please note that I cant merge the tables because there so many similar tables. This should be achieved with Modelling tab only.
As per my understanding this can be achieved easily with Merge-->Left Outer Join. But I would like to know how to acieve the same in Modelling tab with cardinality
Hi, it looks like inner by default in a visualization, but it's left/right you just need to allow the visualization show the blank or null results.
Try this: https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-show-items-no-data
Hope this helps,
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.?
