Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
Anonymous
Not applicable

Matrix not showing values that aren't matches from related table

https://imgur.com/a/UgF5T8e 

 

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?

1 REPLY 1
kentyler
Solution Sage
Solution Sage

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.





Did this post answer your question? Mark it as a solution so others can find it!

Help when you know. Ask when you don't!




Join the conversation at We Talk BI find out more about me at Slow BI


Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.