Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.