Forum Discussion

s--turn's avatar
s--turn
Helper II
1 year ago
Solved

Concatenated 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 ...
Need Help
  • MFelix's avatar
    MFelix
    1 year ago

    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],
        ", "
    )
MFelix's avatar
MFelix
Super User
1 year ago

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],
        ", "
    )
s--turn's avatar
s--turn
Helper II
1 year ago

Hi again MFelix , I really appreciate your time on this one!  I'm afraid that still doesn't quite work.  I've been trying different versions, but still haven't cracked it.  I think these are the challenges (at least, as far as I can see):

 

* When "How Many Emails" is created in that first SUMMARIZE table, it will only ever be 0 or 1, as the granularity is per contactid, and they either received the email or they didn't.  That means that, in the second SUMMARIZE table, when we compare "How Many Emails" to [Number of Emails Value], we won't be matching correctly.  To get round this, I tweaked that first bit to:

 

 "How Many Emails", CALCULATE(SUM('Emails and Contacts'[Was Delivered]),ALL('Emails and Contacts'[blc_subject]))
 
* Second problem, though - there is no reference to the date in that first SUMMARIZE table.  It's still a list of contactid, subject, and the total number of emails that person has received in the entire period covered by the dataset.  We will not be able to slice this by the Week of Year field which is in the visual.
 
* The second SUMMARIZE table, I believe, resulted in just a list of subjects, in theory matching the "How Many Emails" filter.. but again, I don't see how it could be filtered on Week of Year in the visual, as there is no reference to that field here.
 
I then thought "simple, I will just add a column to that first SUMMARIZE table including the "Week of Year" field"... but I cannot seem to be able to do this.  As the tables are related (see screenshot here), I thought this would be possible, but it just doesn't seem to be available when I write my code. 
 

 

 

 

  • MFelix's avatar
    MFelix
    Super User
    1 year ago

    Hi s--turn ,

     

    If you allow me first of all you have a huge problem on your data model that is the bidirectional filters on all your tables, do not apply this to your calculations since this will make your results not be correct because of the filtering of dimensions by facts.

     

    Can you please share a mockup data or sample of your PBIX file. You can use a onedrive, google drive, we transfer or similar link to upload your files.

    If the information is sensitive please share it trough private message.

     

    • s--turn's avatar
      s--turn
      Helper II
      1 year ago

      Thanks - seems I have some bad habits to unlearn!  It seems like this is quite a lot to untangle, so I'm going to pause work on this report for the time being, and return to it later.  It will take time to mock up a .pbix file, so again that may have to wait.  I appreciate your guidance so far.

      • MFelix's avatar
        MFelix
        Super User
        1 year ago

        Hi s--turn ,

         

        When you need anything and want to pickup on this just let me know.