Stop Tables Removing Empty Values

[Anonymous]

Hi,

I'm hoping this should be quite straightforward.

When you normally add Values to a Matrix table from a different data table (Enrollments table) than the Rows (People table), the Rows that don't contain any data in the Enrollments table get removed.

See below the actual data I'm working with:

BEFORE

People table - 119 people

AFTER

People table with ID added to the "Values" from the Enrollments table. The table now has 78 people, therefore there are 41 people who don't have enrollments.

Objective:

I want to show all 119 people so I can see the people who do not have enrollments (that is the people from the People table who don't have data in the Enrollments table).

Here's the data structure - I'm not using any DAX or measures, just dragging and dropping the fields.

Thanks all!

[Greg_Deckler · Accepted solution]

@Anonymous Try right-clicking Apps in your Rows field well and choose "Show items with no data".

[Anonymous]

Omg that was so easy! I had no idea that was there - thanks so much!!