Forum Discussion
Calculate Tooltips
Hello all,
This is a sample of my data (I would love to upload the BI file but only certain users can do that):
| Date | Live | Question | |
1/2023 | 2774 | 249 | 431 |
| 2/2023 | 2683 | 156 | 214 |
| 3/2023 | 3686 | 205 | 183 |
| 4/2023 | 3067 | 174 | 149 |
| 5/2023 | 3566 | 150 | 221 |
| 6/2023 | 3471 | 196 | 225 |
| 7/2023 | 2967 | 158 | 197 |
| 8/2023 | 3549 | 171 | 274 |
| 9/2023 | 2938 | 145 | 199 |
etc...
This is my graph, which I connected to a date table:
I'm hovering over a data point in the above picture.
Is there anyway to get these data points to show both the whole numbers and the percentages? Right now it's just showing the whole number.
For instance, for that particular data point, Feb 23, there were 3,053 total incidents (which is the sum of the 3 fields)
The % breakdowns would be live 2683/3053 = 88%
question 156/3053 = 5%
email 214/3053 = 7% (these %'s are what I also want to show for each data point)
I know tooltips could help, but i'm not sure what DAX i would need to calcuate the %'s.
Any assistance would be greatly appreciated.
Thank you!
Hi,
Assuming you have a fact table with columns/measures: Live, Question, and E-mail and each presumably a count per row, and a Date dimension table related to fact table.
I think your Measures on Y-axis are already something like:
Live = SUM('table'[Live])then your monthly total would be
Monthly Total = [Live] + [Question] + [E-mail]and your Percent would be
Live % = DIVIDE([Live], [Monthly Total]) Question % = DIVIDE([Question], [Monthly Total]) Email % = DIVIDE([E-mail], [Monthly Total])For the tooltip, you may use ToolTip page instead of default tooltip. You can place either a matrix visual or Multi-card visual on the tooltip page. On my demo file it will show as below
In case you need more about tooltip page you can refer to
Create report tooltip pages in Power BI - Power BI | Microsoft Learn
Hope this answered your question:)
7 Replies
hello e175429
i think you might be interested in creating custom tooltips.
Create report tooltip pages in Power BI - Power BI | Microsoft Learn
Thank you.
Hey Irwin,
Thank you for your recommendation page. However, nothing there guided me on how to calculate what I needed.
Regards
Hi,
Assuming you have a fact table with columns/measures: Live, Question, and E-mail and each presumably a count per row, and a Date dimension table related to fact table.
I think your Measures on Y-axis are already something like:
Live = SUM('table'[Live])then your monthly total would be
Monthly Total = [Live] + [Question] + [E-mail]and your Percent would be
Live % = DIVIDE([Live], [Monthly Total]) Question % = DIVIDE([Question], [Monthly Total]) Email % = DIVIDE([E-mail], [Monthly Total])For the tooltip, you may use ToolTip page instead of default tooltip. You can place either a matrix visual or Multi-card visual on the tooltip page. On my demo file it will show as below
In case you need more about tooltip page you can refer to
Create report tooltip pages in Power BI - Power BI | Microsoft Learn
Hope this answered your question:)
Thank you for your reply.
I did not create measures for the y-axis. I just dragged and dropped them from my table.
So i did not need any measures like this:
Live = SUM('table'[Live])I just imported my table from excel and dragged those columns to my y-axis.
Hi e175429
So if you just drag the fields from table, that would be Implicit measures generated by Power BI itself. In this case i'd suggest using Explicit measures like
Live = SUM('table'[Live])to aggregate your data properly and follow the rest of my calculation approaches in the last message.
For the differences between these two different measures you may find more from Radacad below.
Explicit Vs Implicit DAX Measures in Power BI - RADACAD
Hope this helps:)
