Applying a tooltip for different quarters

[daledale]

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.

[parry2k]

@daledale how you want to see the comments to be?

[daledale]

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]

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]

Thanks,

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

[Anonymous]

HI @daledale,

Can you please share some dummy data with the expected results for test and coding formula?

How to Get Your Question Answered Quickly 
Regards,

Xiaoxin Sheng