Relationship between table and line chart

[georgesmith4268]

Hi all,

I'm trying to create a relationship between a table and a line chart.

The table is a ranking of participants, it has two columns, the first one displays the name of each participant and the second one the last score of each participant.

I've also created a line chart displaying the evolution of the score of each participant each year.

What I would like to do is to be able to display the evolution of each participant's score by selecting his name in the table.

The line chart would change according to the selected name.

Does anyone knows how to do such a thing ?

Thank you for your help

[v-jianpeng-msft · Accepted solution]

Hi, @georgesmith4268 

Let's say your datasheet looks like this:

table1:

If you need to interact between two tables, you need to reverse pivot the following schedule in PowerQuery and convert it to the following example:

To establish a relationship between the new table and table1:

Set it up in the line chart visual as follows:

When I click on a name in the table visual, the line chart changes with it.

I provide the PBIX file used this time below.

How to Get Your Question Answered Quickly

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards

Jianpeng Li

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