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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
Back2Basics
Resolver I
Resolver I

Tooltip to filter on row but not by page slicer

I have a report where I have a table for a number of products. The table shows the product ID and then columns for number of sales, profit. 

On the report page I have a slicer for year, so that users can select the year they are interested into see the figures for that year. 

I have a tooltip that shows the history for sales numbers, so displays year on the x-axis and sales on y-axis. I want this tooltip to show the history for a prodcut when hovering over it BUT at the moment it just displays the figure for that years selected in the slicer. I have turned off 'keep all filters' on the tooltip but then it displays the total sales for all products in those years. 

Has anyone successfully managed to achieve something like this before?

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@Back2Basics , add what you want to filter in drag parameters

 

Power BI Tooltip Page: How to pass selective values to the tooltip page: https://www.youtube.com/watch?v=lEq7YtkxeLU

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

View solution in original post

2 REPLIES 2
amitchandak
Super User
Super User

@Back2Basics , add what you want to filter in drag parameters

 

Power BI Tooltip Page: How to pass selective values to the tooltip page: https://www.youtube.com/watch?v=lEq7YtkxeLU

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Many thanks @amitchandak 
I realised I had a field from a different table in one of the drill'through field sections. Great video 👍

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Top Solution Authors