Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Priyamxylem
New Member

Visuals dynamic data hiding

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

Priyamxylem_0-1741763554186.png

 

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

 

Priyamxylem_1-1741763554195.png

 

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 

1 REPLY 1
MFelix
Super User
Super User

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...


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

Check out the February 2025 Power BI update to learn about new features.

Feb2025 NL Carousel

Fabric Community Update - February 2025

Find out what's new and trending in the Fabric community.