Add to line chart: # of records for each unique combo of timepoint/intervention group

[VMorris]

I have a longitudinal dataset tracking participants' scores on several validated measures across multiple time points. Participants are assigned to one of two groups. I have created line charts to show changes in participants' average scores over time (example in screenshot 1). However, when hovering over a specific dot (group/time point combo) on any visual, I would like to have it display the number of records used to calculate that score. Can anyone help me to do this?

My temporary solution has been to create a stacked bar chart showing participants per group by timepoint (screenshot #2). However, this is not ideal because not every participant at each timepoint completes all measures. E.g., there may be 26 participants in the Intervention group at the 3 Mo. Post-Injection timepoint, but only 23/26 may have completed the PROMIS Anxiety measure. 

[VMorris]

Hi @Ritaf1983 

Table with sample data below. Desired outcome is a data element that can be added to the tooltip so that when end-users hover over a datapoint in the line chart, the number of participants used to calculate the average AKPS score is shown (example screenshot below). Or the number of participants could be it's own line at the bottom of the tooltip. Thanks!

event_name	Study Arms	akps_sumscore
Pre-intervention	Intervention	70
Post-intervention	Intervention	null
Post-intervention	Control	53
Follow-up	Control	93
Pre-intervention	Control	73
Follow-up	Intervention	100
Follow-up	Intervention	84
Post-intervention	Intervention	95
Pre-intervention	Control	94
Post-intervention	Control	81
Pre-intervention	Control	68
Post-intervention	Intervention	100
Post-intervention	Intervention	97
Post-intervention	Intervention	75
Post-intervention	Control	67
Post-intervention	Intervention	58
Post-intervention	Control	84
Pre-intervention	Control	69
Post-intervention	Control	95
Post-intervention	Control	79
Post-intervention	Control	77
Pre-intervention	Intervention	86
Pre-intervention	Ineligible	55
Follow-up	Intervention	98
Pre-intervention	Intervention	77
Post-intervention	Control	88
Pre-intervention	Intervention	87
Pre-intervention	Control	79
Post-intervention	Control	97
Post-intervention	Control	69
Follow-up	Control	88
Follow-up	Control	75
Pre-intervention	Control	62
Post-intervention	Intervention	90
Post-intervention	Intervention	89
Post-intervention	Control	69
Pre-intervention	Control	73
Follow-up	Intervention	71
Follow-up	Control	73
Follow-up	Control	73
Pre-intervention	Intervention	59
Post-intervention	Control	89
Follow-up	Control	72
Pre-intervention	0	71
Pre-intervention	Intervention	83
Pre-intervention	Control	90
Follow-up	Control	52
Follow-up	Intervention	null
Pre-intervention	Intervention	71
Pre-intervention	Control	87
Pre-intervention	Control	74
Post-intervention	Intervention	60
Follow-up	Control	99
Post-intervention	Control	90
Pre-intervention	Control	71
Pre-intervention	Intervention	70
Pre-intervention	Intervention	63
Pre-intervention	Control	62
Pre-intervention	Control	59
Post-intervention	Intervention	96
Pre-intervention	Intervention	90
Post-intervention	Control	87
Post-intervention	Control	65
Pre-intervention	Intervention	null
Pre-intervention	Intervention	86
Follow-up	Control	61
Follow-up	Control	89
Pre-intervention	Intervention	95
Pre-intervention	Intervention	76
Follow-up	Intervention	76
Pre-intervention	Intervention	89
Follow-up	Intervention	65
Pre-intervention	Control	61
Pre-intervention	Control	75
Post-intervention	Control	60
Pre-intervention	Ineligible	70
Post-intervention	Intervention	76
Follow-up	Control	98
Post-intervention	Intervention	78
Post-intervention	Intervention	80
Pre-intervention	Intervention	69
Follow-up	Control	93
Post-intervention	Control	73
Post-intervention	Control	70
Post-intervention	Intervention	85
Pre-intervention	Intervention	59
Follow-up	Intervention	82
Pre-intervention	Control	56
Pre-intervention	Intervention	null
Pre-intervention	Intervention	62
Pre-intervention	Control	74
Pre-intervention	Control	57
Follow-up	Intervention	91
Pre-intervention	Intervention	78
Follow-up	Intervention	86
Pre-intervention	Intervention	57
Follow-up	Intervention	82
Pre-intervention	Control	67
Pre-intervention	Control	85

[Ritaf1983 · Accepted solution]

Hi @VMorris 
You can generate a custom tooltip, according to your needs.
1. Create a measure for the desired output of  your n:

n = "(n= " & COUNTROWS('Table')&")"

2 . On another page design the wanted tooltip.
i made mine from table + circles :

3 . format the page as a tooltip and for the needed size (according to the visual)

4. modify the tooltip type from the graph and hide the page

Result:

PBIX is attached

more information about customized tooltips here:

https://www.youtube.com/watch?v=cGpBUJpFWrM&t=12s

 If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[Ritaf1983]

Hi @VMorris 

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523