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.
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!
Solved! Go to Solution.
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.
Hi @empoweredbi
Create measure as
Thank you both! Going with reponse #1 as it can be made to look cleaner on a stacked area chart.
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.
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |