TopN students vs selected student

[Data_Lampe]

Hi guys, 

I want to have a graph that compare top10 student grandes vs grade of a selected student.

In the pick the dark blue should display the average grade in each skill for the top 10, while the light blue the grades of the selected student. Can someone, please help me. 

Below is the link to the pbi

https://drive.google.com/file/d/1TtIzleX9wduvXSed8Vufpz3spM_T0Krt/view?usp=sharing 

[v-luwang-msft]

Hi @Data_Lampe ，

Thank you for sharing your solution, perhaps someone else will offer a better one. I will also think about whether there is a simpler solution once I have time.

Best Regards

Lucien

[Data_Lampe]

Hello, everyone,

So far the solution I developed is to

1. have a virtual table of top10 students

2. Make a relationship between the 2 tables

3. Filter the top10 in one graph and disable the interaction with the single filter selection

4 .Overlaid the two graphs

- Top 10 Grades Y6 PAC I = TOPN(10,SUMMARIZE('Test_Data','Test_Data'[Ano],'Test_Data'[Student],"Total Grade",Test_Data[Teste Grade %]),Test_Data[Teste Grade %])

But I guesse there is a better way to solve this question, so just updating my work and sharing with you .

https://drive.google.com/file/d/1TtIzleX9wduvXSed8Vufpz3spM_T0Krt/view?usp=sharing