Table Visual is dropping a row for no reason!

[ahooee]

Hi

I have two tables: 

1- "Transaction Code & Transaction Description" (with two columns: "Transaction Code" and "Transaction Description")

2-  "Function ID & Transaction Code" (with two columns: "Function ID" and "Transaction Code")

The two tables are linked through the "Transaction Code" columns.

I created a visual (table) to have these three columns:

1. "Function ID" (from table "Function ID & Transaction Code")
2. "Transaction Code" (from table "Function ID & Transaction Code")
3. "Transaction Description" (from table "Transaction Code & Transaction Description")

However, as soon as the column "Transaction Description" is added to the visual it drops some of the rows for no reason such as AO03 and AO07 (Function IDs) (screenshots provided).

Note 1: Transactions /SAPAPO/VERDEL (related to AO03) exists in both tables therefore it is expected to appear in the visual with values in all the the three columns.

Note 2: Transaction /SAPAPO/MC8R (related to AO07) exists only in table "Function ID & Transaction Code". Therefore it is expected it appears in the visual with values for the first two columns (Transaction Description blank).

I would appreciate if someone could shed some light and provide a solution.

Thanks

Reza

[ahooee]

Thanks Greg, much appreciated.

[Greg_Deckler · Accepted solution]

@ahooee It's probably because the Transaction Description is blank. Table and matrix visuals automatically filter out blanks. You might be able to get around it using Show Items with No Data: Show items with no data in Power BI - Power BI | Microsoft Learn