Forum Discussion

Fryyy's avatar
Fryyy
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 ...
Need Help
Abduvali's avatar
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's avatar
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

 

 

  • Abduvali's avatar
    Abduvali
    Skilled Sharer
    8 years ago

     

    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