Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Basically what I have is an invoice table and an order table. The tables are linked via a relationship bewteen the order number. When I use the data from the invoice table in a matrix, it does not include the values where there is no order number. The link above is a rudimentary example but basically the same idea. I want to be able to include the negative numbers but since there is no associated order number, they are not being shown in the matrix. Mainly this is due to a slicer from the order table. It can't filter the table if the value doesn't exist in the other. How can I inlcude the missing values?
Your order table has multiple rows with the ID = 0...this will cause problems. What did you mean by assigning an ID of 0 ? You need to assign a unique order number to be able to assign orders to invoices.
Help when you know. Ask when you don't!
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
Check out the November 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 59 | |
| 43 | |
| 42 | |
| 23 | |
| 17 |
| User | Count |
|---|---|
| 190 | |
| 122 | |
| 96 | |
| 66 | |
| 47 |