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.
I have a bar showing the average of five different variables.
I then wrote measures to show the percentile associated with those specific averages, written as follows:
Num 1 Percentiles Measure = IF([Num 1 AVERAGE Measure]<=1, 1, IF([Num 1 AVERAGE Measure]<=1.5, 2,IF([Num 1 AVERAGE Measure]<=3, 4.5, IF([Num 1 AVERAGE Measure]>3, 6, "Unknown"))))
I want the percentiles to show up in the tooltip...but only for the variable that they are associated with.
So when I hover over "Num 1", I want "Num 1 Percentile Measure" to appear in the tooltip.
When I hover over "Num 2", I want "Num 2 Percentile Measure" to appear in the tooltip.
Is this possible?
As of now, I get all of them (just showing two as an example) for every single bar that I hover over.
So for the above picture, because I am hovering over Average of Num 1, I dont want "Num 2 Percentile Measure" to show up.
But I dragged that measure into my tooltip, because when I hover over Average of Num 2, I do want it to appear.
Any help would be appreciated!
Thanks (:
Solved! Go to Solution.
You probably want to use a Report Tooltip for this. You don't have a lot of control over the basic tooltips. See this article.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingYou probably want to use a Report Tooltip for this. You don't have a lot of control over the basic tooltips. See this article.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingYou are right, that worked perfectly! Thanks!
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 |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |