Edit Tooltip First/Last! Middle??

[Fryyy]

Hello Community,

i have a problem with the tooltip. Normaly you can show the first and the last value if there are no numbers in it.

E.g. i have 3 values (Station1, Station2, Station3) at the same time. If i choose first and last in the Tooltip it only shows Station1 and Station3. Is it possible to show Station2 somehow in the Tooltip?? Maybe with a measure or something else?

It would be also ok if they all are in one Tooltip like "Station: Station1 & Station2 & Station3".

Would be great if you could help me.

Greetings

[Vvelarde · Accepted solution]

@Fryyy

Hi, You can use a Quick Measure to obtain this:

Please Follow the steps in the image

Regards

Victor

Lima - Peru

[v-haibl-msft · Accepted solution]

@Fryyy

You can also create a simple measure using CONCATENATEX Function.

Best Regards,
Herbert

[Fryyy]

@v-haibl-msft 

that is exactly what i wanted! Thank you!

[Vvelarde · Accepted solution]

@Fryyy

Hi, You can use a Quick Measure to obtain this:

Please Follow the steps in the image

Regards

Victor

Lima - Peru

[Abduvali]

Hi @Fryyy,

Not sure if you tried this:

Try to create a measure and drop them into Tooltips:

Tooltip function

Hope it helps.

Regards

Abduvali

[Fryyy]

Sorry but i dont understand what you mean!

what do i have to put in the Measure??

E.g. i have something like that

Time            Station

10:30:00      Station1

10:30:00      Station2

10:30:00      Station3

If i put the column "Station" into the tooltip i can choose "first" and "last"

The Tooltip would be like that.

Time:                 10:30:00

First Station:      Station1

Last Station:      Station3

But i also need to show Station2 in this tooltip.

Can someone help me??

[Abduvali]

@Fryyy,

Just create separate measures for all stations and drop into Tooltip:

• Station 1 = CALCULATE(sum(Sheet1[Time          ]),Sheet1[ Station] = "station1") 
• Station 2 = CALCULATE(sum(Sheet1[Time          ]),Sheet1[ Station] = "station2") 
• Station 3 = CALCULATE(sum(Sheet1[Time          ]),Sheet1[ Station] = "station3") 

Tooltip

Regards

Abduvali

[Fryyy]

Thats quiet good but not exactly what i want.

Is it also possible like that?

Time:           10:30:00

Station:        Station1

Station:        Station2

Station:        Station3

or like that

Time:           10:30:00

Station:        Station1, Station2, Station3

[Abduvali]

You can have it any way you want:

Create this measure and drop into tooltips:

Station: = 

"Station 1: " & CALCULATE(SUM(Sheet1[Time          ]), Sheet1[ Station] = "Station1") & "
" &
"Station 2: " & CALCULATE(SUM(Sheet1[Time          ]), Sheet1[ Station] = "Station2") & "
" &
"Station 3: " & CALCULATE(SUM(Sheet1[Time          ]), Sheet1[ Station] = "Station3")

Hope this will solve your issue.

Regards

Abduvali