Hi,
I have a map with the population in balls divided by race, the size of each ball is determined by the population. Here are my columns in the RacialPopState table:
State or territory
Race
Population
My problem is that the balls are small and the distribution of the races is not clear and I don't want to enlarge them, so I thought of making a tooltip that would display the ball of the map with the race subdivision but larger . Here is the formula I use to display the tooltip:
CALCULATE (SUM ('RacialPopState' [Population]); RacialPopState [State or territory]; ALL ('RacialPopState' [Race]))
But the filter context is still active when I hover over the mouse pointer over the ball and it doesn't show division by race because it always filters. Who has an idea?
Thanks
@esquiveljc this what you need to do, on tooltip page turn off Keep all filters and add state/province column on the drill-down and that will do it. In the following screenshot, I turned off Keep all filters and added the Id column from my model, in your case, it will state/province column
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
@esquiveljc yes it will be, I would recommend not to put a legend on the map and then in tooltip use pie chart to show the distribution.
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Hi @parry2k ,
Yes, it's pie chart which I use in my tooltip. I also deactivated the legend but it does not work yet, I thought that my problem was in DAX?
Thaks
@esquiveljc this what you need to do, on tooltip page turn off Keep all filters and add state/province column on the drill-down and that will do it. In the following screenshot, I turned off Keep all filters and added the Id column from my model, in your case, it will state/province column
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Power BI Monthly Update - January 2025
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
A Year in Review - December 2024
Find out what content was popular in the Fabric community during 2024.
