Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
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.
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.
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
@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.
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
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]))
Hope it resolves your issue? Did I answer your question? Mark my post as a solution! Appreciate your Kudos, Press the thumbs up button!! Linkedin Profile |
@Anonymous - Difficult to trouble shoot without sharing the PBIX. Can you at least screen shot the Tooltip page configuration?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
97 | |
78 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |