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

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

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

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

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
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

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

June 2025 community update carousel

Fabric Community Update - June 2025

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