Forum Discussion
TopN students vs selected student
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, wh...
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