Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
97 | |
81 | |
77 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |