Forum Discussion

Advocate II

8 years ago

Solved

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

Vvelarde
8 years ago
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
8 years ago
Fryyy

You can also create a simple measure using CONCATENATEX Function.

Best Regards,
Herbert
Edit Tooltip First Last! Middle.pbix27 KB

Skilled Sharer

8 years ago

Not sure if you tried this:

Try to create a measure and drop them into Tooltips:

Tooltip function

Hope it helps.

Regards

Abduvali

Fryyy
Advocate II
8 years ago
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
  Skilled Sharer
  8 years ago
  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
    Advocate II
    8 years ago
    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