Calculate Tooltips

[e175429]

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!

[MasonMA · Accepted solution]

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

[e175429]

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. 

[MasonMA]

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

[e175429]

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

And your solution worked. Thank you very much!

[MasonMA]

Happy to see it works:) !

[Irwan]

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.

[e175429]

Hey Irwin,

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

Regards