Table visual removing rows if no data in one column

[tullnd]

I'm fairly new to this level of report.  I have 3 distinct data sources.  They all have date columns and ID columns (think corporate identification).

I'm trying to present a table that displays, by date of occurrence, events that occurred in Source A (will only appear as a line item if there is a record in Source A on that date for that ID) and data, if present, from Source B and data, if present, from Source C, all as  additional columns.

I did create a Date Table and an ID table for this.

I can mostly get it to work, but I'm having issues with how it's displayed.  If I have 5 rows of results from Source A, it'll display fine.  When I add in data from Source B (specifically a measure, combining values from 3 columns), it'll reduce the rows to only show the results where Source B had data.

I verified there's no filter set for "0" or null values.  

I want the rows to still display if there's no data from Source B, but can't figure out what I'm doing wrong.  

[lbendlin · Accepted solution]

there's a setting "show items with no data"  for both row and column values.  Try it out.

[vicky_ · Accepted solution]

Try to right click on a field then click on "show items with no data", or change your measure to return something if there's no result for the measure. 

The rows for Source A are hidden because your measure(s) aren't returning anything.

[lbendlin · Accepted solution]

there's a setting "show items with no data"  for both row and column values.  Try it out.