Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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.

Reply
WOLFIE
Helper I
Helper I

Dynamic page tooltip for matrix

Hi all

 

Could you please help me solve this one? Groups C and D have a rolling count of events. The tooltip shows only the event that happened in the selected month. I need it to show all historical events between the start and end date, or if the end date is blank, then today's date, however, only for groups C and D.

WOLFIE_0-1707995896874.png

file link: https://www.dropbox.com/scl/fi/ab0cot16qug1go6d178x7/sample-file.pbix?rlkey=j02c0uagp6liiy8amlhgppff... 

1 ACCEPTED SOLUTION

Hi,

 

Finally, I think I've found a solution for your problem.
Please watch the gif below and if you need give me your email and I will send you the pbix.
PS. On the gif I forgot to show this formula 

_AAndrade_0-1708038028006.png


Gif:



Tooltip Help.gif





Did I answer your question? Mark my post as a solution! Kudos are welcome.

Proud to be a Super User!




View solution in original post

8 REPLIES 8
_AAndrade
Super User
Super User

I can not download the pbix file. Can you share it in other way?





Did I answer your question? Mark my post as a solution! Kudos are welcome.

Proud to be a Super User!




I added a new link. I hope this works. 

I sent a request to have permition to access the file on one drive 





Did I answer your question? Mark my post as a solution! Kudos are welcome.

Proud to be a Super User!




On the tooltip page put the measure "Count Event" in the table visual (and after hidden the column if you want).
And with this you will get this tooltip on the Page 1:

_AAndrade_0-1707999339356.png

 





Did I answer your question? Mark my post as a solution! Kudos are welcome.

Proud to be a Super User!




Thank you. However, this isn't working as expected. The tooltip needs to show the record number matching the value in the cell.

Hi,

 

Finally, I think I've found a solution for your problem.
Please watch the gif below and if you need give me your email and I will send you the pbix.
PS. On the gif I forgot to show this formula 

_AAndrade_0-1708038028006.png


Gif:



Tooltip Help.gif





Did I answer your question? Mark my post as a solution! Kudos are welcome.

Proud to be a Super User!




Thank you so much. This is exactly what I need! 🙂 my email l.wolfova@gmail.com

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.