cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper IV
Helper IV

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

community 4.PNG

community 5.PNG

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Re: tool tip report page

Hi @AlekseiNexa 

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

1.png

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.

2.png

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

3.png

Let's see the result.

4.png

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. 

View solution in original post

6 REPLIES 6
Highlighted
Super User IV
Super User IV

Re: tool tip report page

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


---------------------------------------

@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Highlighted
Community Champion
Community Champion

Re: tool tip report page

HI @AlekseiNexa 

 

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


Hope it resolves your issue? Please consider accepting it as the solution to help the other members find it more quickly.


Appreciate your Kudos, Press the thumbs up button!!👍


Regards,
Pranit


Highlighted
Super User IV
Super User IV

Re: tool tip report page

@AlekseiNexa , 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.



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Highlighted
Community Support
Community Support

Re: tool tip report page

Hi @AlekseiNexa 

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

1.png

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.

2.png

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

3.png

Let's see the result.

4.png

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. 

View solution in original post

Highlighted
Helper IV
Helper IV

Re: tool tip report page

I dont see how I can upload the file here but you can download it from this link. I am really sorry I was kinda of busy and I took a while to remove sensitive data

 

 

https://drive.google.com/file/d/19dvI-_njEHTn-r5RlgyFUnwYUX3dS79F/view?usp=sharing

Highlighted
Helper IV
Helper IV

Re: tool tip report page

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

Helpful resources

Announcements
Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Top Kudoed Authors