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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
puneethjp
Helper II
Helper II

Clicking on one column value in matrix interacts with one visual

Hi, 

 

We have a matrix table with three columns as shown below. We have two visuals a bar chart and a line chart. Every time the client clicks on any values under "Actuals": the bar chart and line chart should change/interact. Simlarly, 

 

Every time the client clicks on values under Delta, only the bar should interact, the line chart should stay constant.

 

Note: The bar chart on clicking delta value is different(another) from the bar chart appeaering when clicked on Actuals. We may consider another page for the second bar chart if it is feseable solution. 

puneethjp_0-1697020016979.png

Thanks

Puneeth

 

2 REPLIES 2
rubayatyasmin
Super User
Super User

Hi, @puneethjp 

 

Check out the edit interaction option in power bi. edit interaction works visual to visual. you might want to consider another page for the second bar chart to interact with the delta col. remember to set the interactions properly.  

 

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

 

rubayatyasmin_0-1689517080227.png


Did I answer your question? Mark my post as a solution!super-user-logo

Proud to be a Super User!


Hi @rubayatyasmin Thank you for the early response. 

 

As mentined above, we are not looking for a visual to visual interation. In the matrix we have a certain column Delta, it has a list of values. Every time you click on any of that particulat values, the second bar only should interact and respond. 

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

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