Forum Discussion

daledale's avatar
daledale
Frequent Visitor
6 years ago

Applying a tooltip for different quarters

Hi everyone,    I'm trying to add a tooltip (either as the default hover text globe, or as an additional report page). I have a line chart with 4 Quarter (Q1, Q2...) and 4 lines (one for each budg...
Need Help
parry2k's avatar
parry2k
Super User
6 years ago

daledale how you want to see the comments to be?

daledale's avatar
daledale
Frequent Visitor
6 years ago

Something like this:

By using this slot to apply the comments:

The issue that I'm having is that is showing the same comment for each quarter, always the one for Q1. 
It respects the budget if I change it with a slicer/filter, but the comment is always the one for Q1.
My comment table has Budget/Quarter/comment. 

I belive that the issue is that when I go to Model, I need to stablish a relationship between the Quarter in my Comments Table and the table with the data for the graph.. But I'm not sure...

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    HI daledale ,

    If you drag column on tooltip field, it will force enabled summary mode, first/last/count on it to handle aggregate records. I'd like to suggest you write a message with CONCATENATEX function and use on tooltip fields to display all related items:

    Measure = CONCATENATEX(VALUES('Table'[CType]),[CType],",")

    Regards,

    Xiaoxin Sheng

    • daledale's avatar
      daledale
      Frequent Visitor
      6 years ago

      Thanks,

       

      The text is dispalyed correctly, but the problem is that displays the same for each quarter.