Visualise by ranking text instead of value

[PBISam]

Hi,

This may have been solved before, but part of the problem is working out the search terms.

I have a simple table that shows users playing various games on different dates and the score they achieved.

User	Date	Game	Score
User1	01/01/2021	Game1	200
User1	02/01/2021	Game2	150
User1	03/01/2021	Game3	400
User2	01/01/2021	Game1	650
User2	02/01/2021	Game4	300
User3	01/01/2021	Game1	20
User3	04/01/2021	Game2	290
User3	02/01/2021	Game5	300

With this I can create a simple visual and slicers, like so:

I then have another table like this:

Game	ScoreFrom	ScoreTo	Test
Game1	0	200	Poor
Game1	201	400	Average
Game1	401	600	Good
Game1	601	null	Amazing
Game2	0	300	Poor
Game2	301	500	Good
Game2	501	null	Amazing
Game3	0	100	Poor
Game3	201	450	Good
Game3	451	null	Amazing
Game4	0	400	Poor
Game4	401	550	Good
Game4	551	null	Amazing
Game5	0	20	Poor
Game5	21	400	Good
Game5	401	null	Amazing

 

This table gives a textual ranking for each score band.

You will note that each Game has different bands.

What I want to do is show the score band on the Y axis, instead of the actual score.

User1 and User3 on Game1 did 'Poor'.  Whereas User2 did 'Amazing'.

I want to be able to show User1, User2 and User3 on the visual with clustered bar chart and a column for User1 upto the word Poor, same for User2, but User3 up to Amazing.  The words Poor, Average, Good and Amazing still need to be a rising scale.

Essentially the words are replacing value ranges.  I realise that multuiple games could not be displayed, as they have different ranges to each other.

Is this possible?

I would upload an attachement as stated in the guide post, but I cannot seem to do this (no attachment button, dropping on file states .pbix not supported).

Sam.

[Greg_Deckler]

@PBISam To the best of my knowledge Y axis columns/measures have to be numeric. There may be a custom visual where this is not the case.