Interactions between two visuals only for selceted column

[maflingo]

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!

[ray_aramburo]

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

[maflingo]

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?

[maflingo]

Sure, here you go 🙂 

domain	month	average_score
air-up.com	2024-09-01 00:00:00	39.84173
air-up.com	2024-10-01 00:00:00	39.68574
air-up.com	2024-11-01 00:00:00	29.56533
air-up.com	2024-12-01 00:00:00	42.78474
amorelie.de	2024-09-01 00:00:00	51.56147
amorelie.de	2024-10-01 00:00:00	37.26164
amorelie.de	2024-11-01 00:00:00	50.02691
amorelie.de	2024-12-01 00:00:00	63.16355

[Anonymous · Accepted solution]

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 Xu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[maflingo]

Hi Yulia, I do have a slicer that performs the filtering as you described, but in addition to that, I want to filter from the table. But it's only a matter of convenience, if there isn't a way to do this, then I'll just have to settle for filtering only through the slicer. Thanks!

[Anonymous]

Hi @maflingo 

After testing, filtering from the original table doesn't achieve this effect, and another table needs to be created to do so. In my opinion, this method is not as good as using a slicer. But I still write the test procedure below for your reference:

1. Create a calculated table as follows

Table 2 = VALUES('Table'[domain])

2. Create a measure as follows

Measure = IF(SELECTEDVALUE('Table 2'[domain]) = BLANK(), 1, IF(MAX('Table'[domain]) = SELECTEDVALUE('Table 2'[domain]), 1, 0))

3. Put the measure into the visual-level filters, set up show items when the value is 1.

It's worth mentioning that here you need to put the domain field of Table1 into Legend.

Output:

Best Regards,
Yulia Xu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.