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

 

I want to hover over and also get a comment for each Q, but for some reason all I get is always the first comment (Q1).

Maybe it has to do with how I have my data for the comments (a table with 3 columns: Budget, Quarter, Comment). But I'm not sure what I'm doing wrong.

 

Thanks for any advice.

Need Help

5 Replies

    • 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