Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Top 3 scorers

Hi there,

 

I want to find the top 3 scores from my data sets , where in threshold differs. 

 

Can you please help me .

 

 

 

 

 

Need Help
  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    3 years ago

    Hi Anonymous ,

    According to your description, here's my solution.

    After you create the below measure.

    Create another measure.

    Rank =
RANKX ( ALL ( 'Dataset 2' ), [Measure] )

    Put Mark and Name in a column chart, then put the measure Rank in the visual filter and set the value is less than or equal to 3. Get the result.

    In this way, it's also easy if you want to apply conditional formatting. Select Name>Conditional formatting>Backgroud color.

    Then select Rules in the Format style and select measure Rank <=3 then yellow:

    Result:

    I attach my sample below for your reference.

     

    Best Regards,
    Community Support Team _ kalyj

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

     

     

5 Replies

  • Bifinity_75's avatar
    Bifinity_75
    Solution Sage
    3 years ago

    Hi Anonymous , create a calculate column with this formule:

    Rank = 
var ranking= RANKX('Table', 'Table'[Mark],'Table'[Mark],DESC)
return
if (ranking<4,"yellow","")

     

    - Go to conditional format in a Table (visual object), select serie "Name" like the image:

     

    - In Background color (conditional formatting) select this values in the field:

    - The result:

     

    Best regards

     

     

     

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hello Bifinity_75,

     

    I tried comprehend in a different way, Since threshold can be considered as target value for marks, I calculated KPI percentage for each scores  and applied Rank x formala.

     

    Let me know your views on my solutions. 

     

    Thank you again for your solution. 

     

     

     

  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    Community Support
    3 years ago

    Hi Anonymous ,

    According to your description, here's my solution.

    After you create the below measure.

    Create another measure.

    Rank =
RANKX ( ALL ( 'Dataset 2' ), [Measure] )

    Put Mark and Name in a column chart, then put the measure Rank in the visual filter and set the value is less than or equal to 3. Get the result.

    In this way, it's also easy if you want to apply conditional formatting. Select Name>Conditional formatting>Backgroud color.

    Then select Rules in the Format style and select measure Rank <=3 then yellow:

    Result:

    I attach my sample below for your reference.

     

    Best Regards,
    Community Support Team _ kalyj

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

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Hi,

       

      Thank you for the solution. 

      But once I add  the Rank in to visual filter , my visual looks like below , unlike yours .

      Also , Threshhold less than 3 keeps disappearing .

      • v-yanjiang-msft's avatar
        v-yanjiang-msft
        Community Support
        3 years ago

        Hi Anonymous ,

        According to your snapshot, there're three incorrect points.

        1. Visual filter is for bar chart-2, not table visual-1. 

        2.Don't need to put Rank column to the bart chart.

        3.Put Rank to visual filter, not Thredhold.

        I attach my sample below, you can download it to see the details.

         

        Best Regards,
        Community Support Team _ kalyj

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