Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
olimilo
Responsive Resident
Responsive Resident

Dynamic Tooltip on bar charts

Using the following data structure, is it possible to have a dynamic tooltip for each column of my bar chart?

 

NameSystem UpdateQC CheckAccomplishmentCommunication
A3323
B3433
C2133
D2223
E4323
F4233
A3323
B1133
C2124
D3333
E3423
F2433

 

I will be averaging those scores and placing the four columns as Value fields on a bar chart. The content of the tooltip should be the one on the table beside the chart. In the System Update, when the user hovers that bar, the tooltip should say "Needs improvement" (and so on). Is this possible?

 

2017-09-12 14_23_27-Review - Power BI Desktop.png

1 ACCEPTED SOLUTION

Hi @olimilo,

You can create 4 measure for four categories, and create a card visual for each category. We can't use measure in text box, so we display measure in card visual. If you create a measure for System update, please use the similar sturcture formula.

description=IF(AVERAGEX(FILTER(Table,Table[category]=System update),Table[scores])<3.00,"Need to improved", IF(AVERAGEX(FILTER(Table,Table[category]=System update),Table[scores])<3.99,"Satisfactory","Good"))


Best Regards,
Angelia

View solution in original post

7 REPLIES 7
v-huizhn-msft
Employee
Employee

Hi @olimilo,

Untill now, we must put a field into tooltip or legend box to have it appeared when hover on data point in visual. It is impossible to set some description text as dynamic tooltip hwne you hover the visual. Please review and vote this idea.

 

Regards,
Angelia

Hi @v-huizhn-msft, is there no measure that I can use to check if the average of the scores for that column would fall on a particular range? eg: if it falls on 3.00 - 3.99, it should display satisfactory, etc

Hi @olimilo,

Have you resolved your issue? If you have, welcome to share your solution or mark the right reply as answer. More people will benefit from here.

Best Regards,
Angelia

Hi @olimilo,

You can create a measure using the formula.

description=IF(AVERAGE(Table[scores])<3.00,"Need to improved", IF(AVERAGE(Table[scores])<3.99,"Satisfactory","Good"))


But we can't set the measure to appear when we hover any bar. We just can display the measure in a visual. When you click one bar, the measure value changes automatically.

Best Regards,
Angelia

Hi Angelia,

 

Is it possible to use this on a context where it applies to each column?

 

description=IF(AVERAGE(Table[scores])<3.00,"Need to improved", IF(AVERAGE(Table[scores])<3.99,"Satisfactory","Good"))

The code above would only work on 1 column, as of now, I have 4 different columns for the 4 rating categories (System update, QC Check, Accomplishment, Communication). Like, if the user would hover over the System update column, it would get the description for the rating for that column only, QC Check description when the user hovers only on the QC Check chart and so on?

Hi @olimilo,

You can create 4 measure for four categories, and create a card visual for each category. We can't use measure in text box, so we display measure in card visual. If you create a measure for System update, please use the similar sturcture formula.

description=IF(AVERAGEX(FILTER(Table,Table[category]=System update),Table[scores])<3.00,"Need to improved", IF(AVERAGEX(FILTER(Table,Table[category]=System update),Table[scores])<3.99,"Satisfactory","Good"))


Best Regards,
Angelia

Alright, thanks for the clarification. Although I have to admit that doesn't seem to be a good way of doing things.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.