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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
dytaapr
Frequent Visitor

Conditional formatting tooltip title & tooltip not properly working

Hi,

I have 2 pages, a report page and a tooltip page. In the report, there is a table of KPI items whose tooltips are enabled and display the trend chart performance of the KPI items. I have 2022 and 2023 data with unique codes (each year is different).
I have a problem, on the report page there is a year slicer, when I select any year, when in the third item of the KPI, the tooltip displays data for the entire year (2022-2023) when it should be displayed only the third item in the selected year. Is there any idea to solve this problem?


For the title tooltip, the dax looks like this:

RiskTitle = IF(HASONEVALUE(Risk_Event[Code]), FIRSTNONBLANK(Risk_Event[Risk Event], ""), """Please Check on Risk Event below ..""")

 

 

3 REPLIES 3
amitchandak
Super User
Super User

@dytaapr , are you controlling the thrid item on tooltip page?

 

You can use index for that

 

Power BI Index function: Top/Bottom Performer by name and value- https://youtu.be/HPhzzCwe10U

 

The information you have provided is not making the problem clear to me. Can you please explain with an example.

Appreciate your Kudos.

 

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

No, i'm not controlling the third item. 

 

Here, I have a master data table with unique codes for every item. 

Qt/Ql for items in 2022, and Ql/Qt2023 in 2023.

Screenshot 2023-03-27 110910.png

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

and then, in the report page I have a table that contains KPI item and also with their achivements/performances.

In example, if I select 2023 on the slicer, and when I hover over the third item in the table, the tooltip displays something like this:

Screenshot 2023-03-27 111116.png

 

 

 

 

 

 

 

 

however, the tooltip should display like this:

Screenshot 2023-03-27 111148.png

@dytaapr , means you want the report tooltip to ignore the month filter?

refer

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

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.