How to hide row if it doesn't have all informations?

[JBDelvaux]

Greetings,

I have the following table.

The informations it contains come from three tables in DB.  Two of which I easily managed to filter to remove the unnecesary informations.

The result is what you see in the first image. It leaves some line with a blank value where it cannot find correlating value in the filtered tables. I wanted to do the opposite, not show a row if there is no correlating values. How can I achieve that?

To use SQL terms, it feels like the table is doing a OUTER JOIN and I want it to be a INNER JOIN.

Thank you and have a wonderful rest of your day

[christinepayton]

I'm not sure what the model looks like, but one of the merge options in Power Query is an inner join. If you want it to stay in the model and just not show it, you can filter out blanks using a page-level or report-level filter in the filter pane (e.g. drag the ID Client field into the filter pane and advanced filter -> "ID Client" not equals "BLANK". You can hide these filters from viewers with the icon in the corner of the filter card.