Line Chart Show Trend When Row is Selected

[VOPriority]

I have a table visual in Power BI that displays data from the table pr_dcrequirementelement. This table contains the following fields:

• Element Key (Unique identifier for an element)
• Company (Company name)
• Period (e.g., 2024, 2025)
• Goal (a numerical value)

What I Want to Achieve:

• The table shows all rows of table pr_dcrequirementelement(which it does correctly).
• The line chart below the table should update when I select a row.
• The chart should display the Goal for all periods related to the selected Element Key and Company, even when only one row is selected in the table.

Example Data:

 

Element Key	Company	Period	Goal
ABC123	Company 1	2024	30
ABC123	Company 1	2025	35
ABC123	Company 1	2026	50
CDE145	Company 1	2024	70
ABC123	Company 324	2025	75

So when I click either one of the first 3 rows in the table, the line chart should show for x-axis Periods (2024/2025/2026) and for the Y-axis the respective goal values (30/35/50), the 4th row shouldn't display since it's a different key and the 5th row shouldn't display since it's in different company.

I have attempted different DAX measures either in the Y-axis of the line chart or applied as a visual filter to the line chart and cutting interaction with the table visual but nothing worked so far.

[parry2k · Accepted solution]

@VOPriority see attached, tweak the solution as you see fit