cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
empoweredbi
New Member

Show total by year in tooltip

Hello, I have a stacked area chart displaying the number of men and women by year. When a user hovers over a particular year, I want the tooltip to show the total men + women for that year only. Here's the non-working report: https://drive.google.com/file/d/1RJcxZGo1qeeYLeTsNJBJ5dfA2l9VZ6ed/view?usp=sharing

 

For instance, if someone hovers over year 2015, it should say:

Male 7

Female 7

Total 14

 

If someone hovers over year 2017, it should say:

Male 5

Female 14

Total 19

 

Can someone show me how to achieve this? Thank you for your help!

1 ACCEPTED SOLUTION
darentengmfs
Post Prodigy
Post Prodigy

Hi @empoweredbi 

 

Please refer to following article.

 

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-tooltips

 

You just need to define the new page as tooltip, put in a table or a card with Male, Female, and Number from your table. Select the tooltip in your visual under the format tab. When you hover, it will automatically filter by the year you are hovering.

View solution in original post

3 REPLIES 3
FuadAliyev
Frequent Visitor

Hi @empoweredbi 

Create measure as 

Count total Measure = CALCULATE(COUNT(Sheet1[sex]),ALLEXCEPT(Sheet1,Sheet1[year]))
and add this to tooltips 
 
 

 

image.png

Thank you both! Going with reponse #1 as it can be made to look cleaner on a stacked area chart.

darentengmfs
Post Prodigy
Post Prodigy

Hi @empoweredbi 

 

Please refer to following article.

 

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-tooltips

 

You just need to define the new page as tooltip, put in a table or a card with Male, Female, and Number from your table. Select the tooltip in your visual under the format tab. When you hover, it will automatically filter by the year you are hovering.

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.