Forum Discussion
Interactions between two visuals only for selceted column
Hi everyone,
I have two visuals in Power BI; one is a table with the columns domain and score. It is filtered to show only the most recent month for each domain. The undrelying table includse one score for each domain and month. Then I have another graph that shows the development of the score for each domain over time.
When I click on a domain in the table, the graph updates to show only the most recent month for that domain. However, I want it to show all the months for that domain.
Is there a way to fix this?
Thank you!
Hi maflingo
Thanks for the reply from ray_aramburo .
If I understand correctly, you need to filter the Line chart with the table visual that shows the most recent month. According to my test, my suggestion is to add a Slicer to filter the Line Chart. The following test is for your reference.
Select the Slicer visualization and place the domain column into "Field".
Cancel the interaction of the Slicer visual object with the Table visual object to avoid affecting the display of the table.
Select Slicer -> Format -> Edit interactions -> Select None in the upper right corner of the Table table
Output:
Best Regards,
Yulia XuIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
7 Replies
- ray_aramburo
Super User
If I understood your question correctly:
Select the table visual > Go to Format > Edit Interactions. Above the visual you want to adjust the interaction ensure you have selected the "Highlight" option or you can Restrict it as well (the forbidden sign).
Hi Ray, thanks for the suggestion It's not the interaction in general that's the problem, but that it's too specific. When I choose a domain in the table, I get this view with only the latest time point (pic 1), as the table includes only the values from the latest month. What I want is that when I select a domain from the table, it shows me the whole time series for that domain (pic 2).12
- ray_aramburo
Do you have any sample of your data so I can reproduce your scenario?
