Results being filtered if blanks?

[Adam1V]

Hi,

Im still quite new to PBI and hopefully have an easy question.

I have two tables, 'Panel Build' and 'Temp_Timesheets', both linked by a common 'Job Number'.

Im currently displaying a table visual mainly populated with fields from the Build table. This table works fine, until I add 'Build Hours' from the timesheet table and it filters the list down to only contain projects which has values in this column, around 50% less projects.

The Timesheet table alot of time will not contain job numbers contained within the build table as staff would be yet to book them.

Is there a way to prevent this filtering in such a way and leave the cell blank? I noticed other fields have an option 'Show items with no data' however this option is not available to the Build Hours field.

Thanks

[v-yiruan-msft]

Hi @Adam1V ,

Whether you  solved your problem? If no, could you please provide some sample data exclude sensitive? Also please state which fields you want to display on the visual ? We may need to treat the information that needs to be displayed differently . For the option "Show items with no data" as you mentioned earlier , you can select the field " JOB NUMBER " , and right-click to select that option . Check whether the blank value of field " JOB NUMBER " can display.

Best Regards

Rena

[Adam1V · Accepted solution]

I think ive just solved it but someone may be able to expand further. By selecting one of the other fields 'Job Number' for example and selecting 'Show items with no data' will display the missing projects.