Forum Discussion
Tooltip for 100% stacked column chart
I have a 100% stacked column chart as below:
and I would like to hover over each section of the graph with the count of the values.
E.g. there are 3 counts in the 3rd column, if I hover over the 67% part it will show '2' and if I hover over the 33% part it will show '1'.
Create a counting measure,
Count = COUNT('Table (2)'[Column1])then create a new page report and put the measure into the card visual. Set this page to tooltip, and set tooltip in the column chart.
Please refer to this document:
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-tooltips
2 Replies
- mahoneypat
Microsoft Employee
You should be able to create a measure that removes the filter from the column used as your legend in the chart. If the simple COUNT doesn't work, use the appropriate measure/expression.
Count of Values = CALCULATE(COUNT(Table[AnyColumnInTable]), REMOVEFILTERS(Table[LegendColumn]))
Pat
V-lianl-msftCommunity Support
Create a counting measure,
Count = COUNT('Table (2)'[Column1])then create a new page report and put the measure into the card visual. Set this page to tooltip, and set tooltip in the column chart.
Please refer to this document:
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-tooltips
