Skip to main content
cancel
Showing results for 
Search instead 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

Reply
Fryyy
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
Vvelarde
Community Champion
Community Champion

@Fryyy

 

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

 

Please Follow the steps in the image

 

Concatenated.gif

 

Regards

 

Victor

Lima - Peru

 

 




Lima - Peru

View solution in original post

v-haibl-msft
Employee
Employee

@Fryyy

 

You can also create a simple measure using CONCATENATEX Function.

 

Edit Tooltip First Last! Middle_1.jpg

 

Best Regards,
Herbert

View solution in original post

8 REPLIES 8
v-haibl-msft
Employee
Employee

@Fryyy

 

You can also create a simple measure using CONCATENATEX Function.

 

Edit Tooltip First Last! Middle_1.jpg

 

Best Regards,
Herbert

@v-haibl-msft 

that is exactly what i wanted! Thank you!

Vvelarde
Community Champion
Community Champion

@Fryyy

 

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

 

Please Follow the steps in the image

 

Concatenated.gif

 

Regards

 

Victor

Lima - Peru

 

 




Lima - Peru
Abduvali
Skilled Sharer
Skilled Sharer

Hi @Fryyy,

 

Not sure if you tried this:

Try to create a measure and drop them into Tooltips:

Tooltip functionTooltip function

Hope it helps.

 

 

Regards

Abduvali

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

 

@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") 

TooltipTooltip

 

Regards

Abduvali

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

 

 

 

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

Helpful resources

Announcements
Europe Fabric Conference

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 Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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