Forum Discussion

2 Replies

  • v-luwang-msft's avatar
    v-luwang-msft
    Icon for Community Support rankCommunity Support
    4 years ago

    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's avatar
    Data_Lampe
    Regular Visitor
    4 years ago

    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