Forum Discussion
Table visual removing rows if no data in one column
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.
there's a setting "show items with no data" for both row and column values. Try it out.
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.
2 Replies
- lbendlin
Super User
there's a setting "show items with no data" for both row and column values. Try it out.
vicky_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.