Forum Discussion
Solved
Line Chart Show Trend When Row is Selected
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.
