Rank Top 3 by Gold Silver Bronze

[Freeseman]

Good day,

Is there a method of ranking top 3 percentage by color Gold, Silver, Bronze?

[Jihwan_Kim]

Hi,

Could you please write a measure something like below, and put it into the visualization?

Color measure: =
VAR _ranking =
    RANKX (
        ALL ( 'TableName'[Badge number], 'TableName'[Operator Name] ),
        [Performance],
        ,
        DSC
    )
RETURN
    SWITCH (
        TRUE (),
        _ranking = 1, "Gold",
        _ranking = 2, "Silver",
        _ranking = 3, "Bronze"
    )

[Freeseman]

I feel like something is missing from the true () statement?

I am not sure but all cells are gold.

[Jihwan_Kim · Accepted solution]

Hi,

Thank you for your feedback.

I tried to create a sample pbix file like below.

Please try the below.

Please check the attached pbix file as well.

Color measure: = 
VAR _ranking =
    RANKX (
        ALL ( Data ),
        [Performance measure:],
        ,
        DESC
    )
RETURN
    SWITCH (
        TRUE (),
        _ranking = 1, "Gold",
        _ranking = 2, "Silver",
        _ranking = 3, "Yellow"
    )