Dynamic Tooltip on bar charts

[olimilo]

Using the following data structure, is it possible to have a dynamic tooltip for each column of my bar chart?

Name	System Update	QC Check	Accomplishment	Communication
A	3	3	2	3
B	3	4	3	3
C	2	1	3	3
D	2	2	2	3
E	4	3	2	3
F	4	2	3	3
A	3	3	2	3
B	1	1	3	3
C	2	1	2	4
D	3	3	3	3
E	3	4	2	3
F	2	4	3	3

I will be averaging those scores and placing the four columns as Value fields on a bar chart. The content of the tooltip should be the one on the table beside the chart. In the System Update, when the user hovers that bar, the tooltip should say "Needs improvement" (and so on). Is this possible?

[v-huizhn-msft]

Hi @olimilo,

Untill now, we must put a field into tooltip or legend box to have it appeared when hover on data point in visual. It is impossible to set some description text as dynamic tooltip hwne you hover the visual. Please review and vote this idea.

Regards,
Angelia

[olimilo]

Hi @v-huizhn-msft, is there no measure that I can use to check if the average of the scores for that column would fall on a particular range? eg: if it falls on 3.00 - 3.99, it should display satisfactory, etc

[v-huizhn-msft]

Hi @olimilo,

Have you resolved your issue? If you have, welcome to share your solution or mark the right reply as answer. More people will benefit from here.

Best Regards,
Angelia

[v-huizhn-msft]

Hi @olimilo,

You can create a measure using the formula.

description=IF(AVERAGE(Table[scores])<3.00,"Need to improved", IF(AVERAGE(Table[scores])<3.99,"Satisfactory","Good"))

But we can't set the measure to appear when we hover any bar. We just can display the measure in a visual. When you click one bar, the measure value changes automatically.

Best Regards,
Angelia

[olimilo]

Hi Angelia,

Is it possible to use this on a context where it applies to each column?

description=IF(AVERAGE(Table[scores])<3.00,"Need to improved", IF(AVERAGE(Table[scores])<3.99,"Satisfactory","Good"))

The code above would only work on 1 column, as of now, I have 4 different columns for the 4 rating categories (System update, QC Check, Accomplishment, Communication). Like, if the user would hover over the System update column, it would get the description for the rating for that column only, QC Check description when the user hovers only on the QC Check chart and so on?

[v-huizhn-msft · Accepted solution]

Hi @olimilo,

You can create 4 measure for four categories, and create a card visual for each category. We can't use measure in text box, so we display measure in card visual. If you create a measure for System update, please use the similar sturcture formula.

description=IF(AVERAGEX(FILTER(Table,Table[category]=System update),Table[scores])<3.00,"Need to improved", IF(AVERAGEX(FILTER(Table,Table[category]=System update),Table[scores])<3.99,"Satisfactory","Good"))

Best Regards,
Angelia

[olimilo]

Alright, thanks for the clarification. Although I have to admit that doesn't seem to be a good way of doing things.