One table visual filters out all records in another table visual

[cs22]

I have two Table visuals, both are coming from a single table in my data source. I would like to hide the second table based on certain conditions hence I am separating into two Table visuals. However, the moment I add more than one column in my first table, and then I click on a record, all records in the second table is gone. Please see details below.

Notice that when there is only one column in my first table, the filtering to the second table works correctly.

However, when I add another column in my first table, clicking on a row in that first table results for no records to show up (I expect one record should appear).

What do I need to do to resolve this?

[v-easonf-msft]

Hi,  @cs22 

Please check whether the two fields in the first table have  been aggregated or that there are duplicate values in the original table.

As a solution, you might consider creating two identical tables containing these three fields, and then hiding the columns you don't want display by shortening column width(need to turn off ‘word wrap’).

Best Regards,
Community Support Team _ Eason

[amitchandak]

@cs22 , Based on the screenshot, the second table is filtering on C1 and datetime.

Is there any data for this combination is second visual ?

or

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.