topic Re: Calculate Tooltips in DAX Commands and Tips

Calculate Tooltips

e175429 — Wed, 23 Jul 2025 20:44:37 GMT

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	Email
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!

Re: Calculate Tooltips

Irwan — Wed, 23 Jul 2025 22:27:48 GMT

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.

Re: Calculate Tooltips

MasonMA — Wed, 23 Jul 2025 22:51:33 GMT

e175429

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:)

Re: Calculate Tooltips

e175429 — Thu, 24 Jul 2025 14:38:19 GMT

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.

Re: Calculate Tooltips

e175429 — Thu, 24 Jul 2025 14:40:50 GMT

Hey Irwin,

Thank you for your recommendation page. However, nothing there guided me on how to calculate what I needed.

Regards

Re: Calculate Tooltips

MasonMA — Thu, 24 Jul 2025 14:52:33 GMT

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:)

Re: Calculate Tooltips

e175429 — Thu, 24 Jul 2025 15:11:50 GMT

I see. Thank you for the Explicit vs Implicit article, definitely new information to me.

And your solution worked. Thank you very much!

Re: Calculate Tooltips

MasonMA — Thu, 24 Jul 2025 15:25:45 GMT

Happy to see it works:) !