Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I am looking for a solution of this probably simple problem. I have two tables in Power BI: Inventory and Sales:
Inventory Sales
Item Title Item Quantity
123 Soap 124 5
124 Detergent 123 8
125 Toothpaste
126 Tooth brush
How can I make a Table visual that lists items not sold. I.e. I need to return:
Item Title
125 Toothpaste
126 Tooth brush
Solved! Go to Solution.
Mearge or link both table and apply filter in visual (Quantity = Blank)
Mearge or link both table and apply filter in visual (Quantity = Blank)
You can mearge in Query editor or Link in data model. Both options will give you same result
OK, thanks. How do I link tables in Power BI? You mean establish relationship between the two tables?