Filter on the dual axis chart

Hi All,

I have data like this:

I have 2 sheets in tableau workbook:

1. Dual axis chart (bar and shape):

      -  Bar Chart ==> Dimension : Date, Measure : CNTD(ID)

      -  Shape ==> Dimension : Special Flag, Measure : CNTD(ID)

2. Simple Table to show the source data in tabular format

When I combine both sheets in 1 dashboard and use my 1st sheet(dual axis chart) as filter, I encountered this issue:

- When I select the shape, the data in table will be displayed correctly

- But when I select the bar (ex: 1/10/2016), there is no data shown in the table. I realized tableau pass the filter for both dimension (Date and Special Flag) and the Special Flag is NULL value.

Is there a way to show the data only filter by Date when the user select the bar chart?

Please find the attached file for the workbook.

Thank You

Regards,

Ratna