Forum Discussion
Post ProdigyDynamic Tooltip on bar charts
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?
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
7 Replies
v-huizhn-msftMicrosoft Employee
olimiloHi 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,
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