cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Frequent Visitor

## Edit Tooltip First/Last! Middle??

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

2 ACCEPTED SOLUTIONS
Community Champion

@Fryyy

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

Regards

Victor

Lima - Peru

Lima - Peru
Employee

@Fryyy

You can also create a simple measure using CONCATENATEX Function.

Best Regards,
Herbert

8 REPLIES 8
Employee

@Fryyy

You can also create a simple measure using CONCATENATEX Function.

Best Regards,
Herbert

Frequent Visitor

that is exactly what i wanted! Thank you!

Community Champion

@Fryyy

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

Regards

Victor

Lima - Peru

Lima - Peru
Skilled Sharer

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

Frequent Visitor

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??

Skilled Sharer

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

Frequent Visitor

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

Skilled Sharer

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

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

#### New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors
Top Kudoed Authors