Non-numeric y-axis?

[jthomson]

Hi,

I'm looking to create some visuals (either a scatter plot or a line graph probably) to show how competitors in a series of events have done. My data looks a lot like this:

Player	Event 1	Event 2	Event 3
Dan	Win	Last 16	Last 16
Bob	Semi Final	Quarter Final	Win
Andy	Last 32	Quarter Final	Last 64
Mike	Quarter Final	Win	Runner Up
Steve	Semi Final	Last 32	Did Not Play
Gary	Did Not Play	Runner Up	Last 16

Except it's for 20+ events and ~100 players. What I want to do is create a graph that looks something like this:

where the red line shows Dan's performance, the blue Bob's etc.

X-axis isn't a problem, I just unpivot everything apart from the player column and then relate it to an ordering table (i.e. two columns saying event 1, 1; event 2, 2 etc) and sort by column to get things ordered. To get the actual graph also isn't a problem, I just convert values in Power Query (i.e. change win to 6, runner up to 5, semi final to 4 and so on. Where I'm stuck is labelling the y-axis. I can only get it showing values from 0-6 - I know I'm going to have to have numeric data to generate the graph, but can I relate that numeric data to what the numerical values represent somewhere in order to get the y-axis displayed like in the image?

I can work around by removing the y-axis and putting in text boxes, but as I'm going to have three or four of these graphs on my final report I'd rather not have to fiddle like that. I also can't use any custom visuals for this. Any ideas? Thanks in advance

(edited title)

[v-yulgu-msft]

Hi @jthomson,

Currently, Y-axis only supports numeric values, adding text to Y-axis will be aggregated by default. I'm afraid above expected output cannot be achieved right now.

Besides, here is a similar idea: Create line graph with text labels (y-axis) and dates (x-axis)

Regards,

Yuliana Gu