Forum Discussion
Optional relationships
I have two tables that each have a common field. I want to always display data from one table, and info from the second table IF IT EXISTS. So I want a relationship between the two tables based on that field, but if for a record in table one, if that field data is not present in the field in the second table, I do NOT want to drop the data from table 1. This was called an optional join in ACCESS. Other programs called them optional links. How do I do this in Power BI. Thanks in advance!
Hi Bob855 ,
Not sure if I understand the question but if you have a relationship on two tables and you want to show on the visualization the field from table 1 even if the fields in table 2 don't exist you just need to select those fields in the visualization and using right click you can show the items with no data:
Has you can see on the image above the last column refers to information on the second table and selecting the option highlited I'm abble to pick up all the fields on table 1, rest of the columns on the visualization.
Not sure if this is what you intended, if not please elaborate better on what you need to achieve.
1 Reply
Hi Bob855 ,
Not sure if I understand the question but if you have a relationship on two tables and you want to show on the visualization the field from table 1 even if the fields in table 2 don't exist you just need to select those fields in the visualization and using right click you can show the items with no data:
Has you can see on the image above the last column refers to information on the second table and selecting the option highlited I'm abble to pick up all the fields on table 1, rest of the columns on the visualization.
Not sure if this is what you intended, if not please elaborate better on what you need to achieve.