Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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!
User | Count |
---|---|
128 | |
108 | |
100 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |