Forum Discussion
AdministratorValues are not displayed when combining tabala
Hello
I have loaded two excel files in POWERBI and I created a single excel table, what I want is to see the PO N. of one excel and the other who was the person who bought it, but when I make the table the Po that were not bought in my department or the values in $$ disappear and only the ones with a name remain. They know that I can visualize all the values in total.
What I marked in red does not show me the values because it has no relation in the name that has been found, but I need to see the values.
2 Replies
- nandic
Resident Rockstar
Syndicate_Admin could you send screenshot of how you make relationship between tables?
Is it in Power Query using Merge option or in data model using relationships?
If you use Merge option in Power Query, there is option to choose full outer join which will return you all the rows from both tables (both matchin rows and non-matching rows).If you need full outer join using dax, here are some examples:
https://community.fabric.microsoft.com/t5/Desktop/full-outer-join-in-dax/m-p/540609
https://www.cloudfronts.com/blog/power-bi/full-outer-join-using-dax-in-power-bi/
Cheers,
Nemanja Andic
Syndicate_AdminHello, thanks for responding.
I didn't merge table, I just made the relationship in Model View "Reference" is PO in my doc Export and that I related to "PO" in PR-PO ControlCan I visualize without combining the tables or do I need to combine them?
