Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 ..""")
@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.
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:
@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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
26 | |
22 | |
12 | |
8 |
User | Count |
---|---|
76 | |
50 | |
46 | |
16 | |
12 |