topic Re: Conditional formatting tooltip title & tooltip not properly working in DAX Commands and Tips

Conditional formatting tooltip title & tooltip not properly working

dytaapr — Mon, 27 Mar 2023 02:51:38 GMT

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

Re: Conditional formatting tooltip title & tooltip not properly working

amitchandak — Mon, 27 Mar 2023 04:00:41 GMT

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.

Re: Conditional formatting tooltip title & tooltip not properly working

dytaapr — Mon, 27 Mar 2023 07:02:10 GMT

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:

Re: Conditional formatting tooltip title & tooltip not properly working

amitchandak — Mon, 27 Mar 2023 16:36:52 GMT

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