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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

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
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! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

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