Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

tool tip report page

I just discover tool tips and I was trying to use but it is not working. It does not update.
I used the same field so that it can be displayed automatically and it works(1st image) and the values changes. However when I use a KPI visual over a tooltip page report the value stays the same dont matter what I hover on.
As it is shown the is "Produccion" that is over 34...but when I use the tooltip page report it is 1 million. I hover on the same bar - the tallest one
I already watched many videos about this but don know what I am doing wrong



  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi Anonymous 

    Due to I don't know your data model, I build a sample table to have a test.

    I add two calculated columns(Day and Year) in this table.

    DAY = DAY(Sheet1[Date])
    Year = YEAR(Sheet1[Date])

    Then use this table to build a column chart, and build a report page tooltips for Produccion.

    Firstly build a new page and turn on the setting in Page info and choose the type in Page size.

    Then build a Kpi visual and add the Measure in this Kpi. You should check your setting in Red box.

    Let's see the result.

    For more infos to Tooltips: Create tooltips based on report pages in Power BI Desktop

    You can download the pbix file from this link: tool tip report page

     

    Best Regards,

    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

6 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    HI Anonymous 

     

    In your tooltip page you have to sum it based on the X-axis in your chart to get the correct value.

    lets say your x-axis is is a [Date] column.

    then.

    Create the measure for the tooltip pag card as 

    Calculate(sum([Production]), Allexcept(table,table[Date]))

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    6 years ago

    Anonymous , Make sure measure on the visual and measure on the tooltip page should be the same.  Can you share  a sample pbix after removing sensitive data.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Anonymous 

    Due to I don't know your data model, I build a sample table to have a test.

    I add two calculated columns(Day and Year) in this table.

    DAY = DAY(Sheet1[Date])
    Year = YEAR(Sheet1[Date])

    Then use this table to build a column chart, and build a report page tooltips for Produccion.

    Firstly build a new page and turn on the setting in Page info and choose the type in Page size.

    Then build a Kpi visual and add the Measure in this Kpi. You should check your setting in Red box.

    Let's see the result.

    For more infos to Tooltips: Create tooltips based on report pages in Power BI Desktop

    You can download the pbix file from this link: tool tip report page

     

    Best Regards,

    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      I had to add axis on my my tooltip report page just like you did in your red square. I hadnt done that. I added the X axis there and it is working! thank you

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    6 years ago

    Anonymous - Difficult to trouble shoot without sharing the PBIX. Can you at least screen shot the Tooltip page configuration?