hide data with no connection

[Anonymous]

Hi,

I have built a connection between 3 different data sources.  When I build a table/matrix some of the entries find a match from one source to the others and some don't.  Is there way to zero out the ones without a connection.

I would like to zero out or hide all the entries with the 2.744 or 75,985.64

[v-yulgu-msft · Accepted solution]

Hi @Anonymous,

Maybe you could create calculated columns like:

Column1 = IF(RELATED(DataSource_1[Labor Actual Hours])=BLANK(),0,RELATED(DataSource_1[Labor Actual Hours]))

In table visual, add Column1 rather than DataSource_1[Labor Actual Hours].

Optionally, you could combine all necessary columns into a new calculated table, then, filter this table to remove blank rows.

Regards,
Yuliana Gu