Multi select Dropdown control - When selecting an option, do not show empty values

[William Calesco]

Hi folks,

I am new to analytics and having a hard time trying to figure this out:

I have 3 controls for a chart (first row) .. the others are not connected yet.

For these 3 controls - They are multi select and checked to show unselected data, because I want to see everything by default.

But, when I select something, like the example below, the chart also returns empty values

How can I fix that? 

[William Calesco · Accepted solution]

Fixed, the problem was in the JOINs sections. 
I was using LEFT JOIN , changing to INNER JOIN solve this for me