Two visuals with data from the same table will not filter both ways.

[Anonymous]

I have a tab with two visuals containing different fields from the same table. When one record is selected in the top visual, the data from the bottom visual disappears. But a single record selection from the bottom visual filters the top visual properly. I have checked and rechecked the interactions and added unique key fields both visuals to no avail. I have also validated that the records do exist in both visuals and that slicers filter both views correctly.

Thanks

TS

[Anonymous]

Thanks for your response. I thought about your described scenario and even made sure to test values known to exist in both visuals. There are no predefined filters in either visual and the second visual does filter the first. But, when clicking the values that I know exist in both from the first visual, the second visual shows no records. I am digging into the data as I do believe that it may have issues. Again, thanks for your response. I will provide an update if and when this problem is resolved.

[lbendlin]

If you like you can also provide a sample pbix that illustrates the issue. 

https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...

[lbendlin]

If the visuals are fed from the same table then they are also subject to the same filters (unless you modify the interaction settings  which is an interesting approach).  So let's say you filter one visual by a certain column. This may indeed result in the other visual not showing anyting any more because its columns may have blanks for the new filter context.

That is expected behavior on report page level. It may also extend to report level depending on where and how you set the filter.