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

Need Help

8 Replies

  • Vvelarde's avatar
    Vvelarde
    Community Champion
    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

     

     

  • Abduvali's avatar
    Abduvali
    Skilled Sharer
    8 years ago

    Hi Fryyy,

     

    Not sure if you tried this:

    Try to create a measure and drop them into Tooltips:

    Tooltip function

    Hope it helps.

     

     

    Regards

    Abduvali

    • 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