Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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.
@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
Hello, 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 Control
Can I visualize without combining the tables or do I need to combine them?
User | Count |
---|---|
81 | |
76 | |
62 | |
60 | |
48 |
User | Count |
---|---|
109 | |
95 | |
86 | |
79 | |
61 |