Min and Max data labels in a chart

[Anonymous]

Hi,

I have a table of data with Users and their % of scores, I need to add a card which shows value like "The highest % scored by STU with 72.5 % and lowest scored by DEF with 51.2%" 

Name	Data %
ABC	57.94%
DEF	51.19%
GHI	55.41%
JKL	59.38%
MNO	62.30%
PQR	61.25%
STU	72.55%
VWX	60.38%
YZA	55.56%

[v-chuncz-msft]

@Anonymous,

You may also use TOPN in a measure.

[Anonymous · Accepted solution]

How I did (about) the same thing:

Create two cards per value (2 for highest, 2 for lowest). Put the name in one of the cards, and the value in the other. Use the visual filterpane in both cards to filter Name, filter type: Top N. Select Top 1 and put the value in "by value".

Do the same for the bottum one by swithing between top/bottum in the Top N pane.