Forum Discussion
Helper IIConcatenated tooltip - on a bubble plot (or anywhere)
Hello,
I have followed the instructions here to create a concatenated tooltip. However, it doesn't work as expected on a bubble plot (and, actually, when I check it in a matrix, it also doesn't work there):
and in a matrix:
As you can see, the chart shows how many people received a certain number of emails, each week. I know that stakeholders will immediately ask "which emails?". e.g. "seems like a small number of people received four emails in week 12 - what emails were they?". That's what I want the tooltip to answer.
However, if you look at my screenshot, you'll see how it is giving the same result for all bubbles in the same week. e.g. for week 10, the tooltip value is always the same, listing emails "Student newsletter | March 2025", "Digest - 4 March 2025" and "eNews - March 2025". Even when the y-axis value is 0, i.e. people who received no emails that week, it still outputs that list of three emails. This cannot be right... can it?
Any advice gratefully received!
Try this new code:
Emails included = VAR _Emai1sInPeriodPerContact = SUMMARIZE ( 'Emai1s and Contacts', 'Emails and Contacts '[contactid], 'Emails and Contacts '[blc_subject], "How Many Emails", SUM ( 'Emai1s and Contacts'[Was Delivered] ) ) VAR RETURN CONCATENEX ( SUMMARIZE( FILTER ( _Emai1sInPeriodPerContact, [How Many Emails] = 'Number of Emails'[Number of Emails Value] ), 'Emails and Contacts '[blc_subject]) , 'Emails and Contacts '[blc_subject], ", " )
12 Replies
- MFelix
Super User
Hi s--turn ,
This is a question about context, if you are always receiving the same value is because there is no relationship between the Emails and Contacts table and the measure you have created and the information in the axis of the chart.
Can you please add information about how your model is setup and this measure on the chart is created.
s--turnHi MFelix , thanks for the quick reply! The only field in the chart which isn't from the Emails and Contacts table is "Number of Emails", which comes from a parameter. The measure "Contacts with this many emails in period" refers to it:
Oh, and Week of Year comes from a Calendar table, which is indirectly related to Emails and Contacts.
- MFelix
Hi s--turn ,
Try the following code:
Emails included = VAR _Emai1sInPeriodPerContact = SUMMARIZE ( 'Emai1s and Contacts', 'Emails and Contacts '[contactid], 'Emails and Contacts '[blc_subject], "How Many Emails", SUM ( 'Emai1s and Contacts'[Was Delivered] ) ) RETURN CONCATENEX ( FILTER ( _Emai1sInPeriodPerContact, [How Many Emails] = 'Number of Emails'[Number of Emails Value] ), 'Emails and Contacts '[blc_subject], ", " )
v-echaithraCommunity Support
Hi s--turn ,
As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.Regards,
Chaithra E. - v-echaithra
Hi s--turn
As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.Regards,
Chaithra. - v-echaithra
HI s--turn ,
As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.Regards,
Chaithra.