Visuals dynamic data hiding

[Priyamxylem]

I have two visuals one Table and other is Stacked Bar chart. The data coming from both the visuals are from two different table suppose table1 and table2

Relation table1(ID) one to many relation with table2(custid)  and cross filtering is set to both.

Issue – When I select any row from the stacked visual table visuals show only one matched row as you can see below

But when I select one row from table it highlight the selected ID and grey out the unmatched one.

Expectation is that stack bar chart should only show matched id hiding all other ids data. The data is huge so when someone selects a row from the table if that id is at last in stack bar chart then we have to scroll all the way down to the chart to see its matched data.

@PowerBI @powerbi3 @npowerbi @powerbi2 

[v-pagayam-msft]

Hi @Priyamxylem ,
Glad that your issue got resolved.Kindly accept your answer as solution to find others quickly.

Regards,
Pallavi.

[Priyamxylem]

hi @MFelix  it got resolved, not sure what was the issue but when I opened the file the next day it was working fine.

Thanks for looking into this.

[MFelix]

Hi @Priyamxylem ,

This is related with the interactions of the visuals that can be set to filter and to highlight by default its set has highlight but you can change it to filter for a specific visual or has default behaviour.

https://learn.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions?tabs=p...

[Priyamxylem]

@MFelix  The visual is already set to filter

[MFelix]

Can you please share a mockup data or sample of your PBIX file. You can use a onedrive, google drive, we transfer or similar link to upload your files.

If the information is sensitive please share it trough private message.