Change the field value displayed when I hover over a data point

[msuser48]

I have a radar chart with data points.

When I hover over each data point, it displays a column and its value, which I get from using a Measure.

- For example: "Score 1.00" it could say.

The measure I use is: "AvgScore = AVERAGE('Table1'[Score]). Output will ALWAYS either be 1.00 , 2.00 or 3.00. Output can be nothing else.

Instead of this, I need the output to be either 1 - Bad (if the value is 1.00) or 2 - Average (if the value is 2.00) or 3 - Good (if the value is 3.00).

So, maybe this is quite simple. But how do I do this?

[JennyMac73]

Hi Everyone,

How would you do this if you have multiple score columns?

Here is my data below

Group	Score 1	Score 2
Team 1	1	4
Team 2	2	1
Team 3	4	3
Team 4	3	2

The outputs between Score 1 Column and Score 2  Columns differ.

Score Column 1:

1.00  = No understanding , 2.00 = some understanding, 4.00 = Great understanding

Score Column 2:

1 = No controls, 2.00 = some controls , 3.00 = Good control, 4.00= Great controls

Any thoughts on this would be grealty appreciated, and thank you in advance!

[v-yalanwu-msft · Accepted solution]

Hi， @msuser48 ；

You could create a measure then create a tooltip page.

Measure = SWITCH(MAX('Table'[Score]),1,"Bad",2,"Average",3,"Good")

then create a tooltip page.

The final show:

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.