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
Fryyy's avatar
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'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