Conditional formatting tooltip title & tooltip not properly working

[dytaapr]

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 ..""")

[amitchandak]

@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.

[dytaapr]

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.

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:

however, the tooltip should display like this:

[amitchandak]

@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