Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! It's time to submit your entry. Live now!
Hello
I created a map with different locations but I need each point to turn green, yellow, or red (traffic light) according to an indicator of my model. It is a column that indicates the level of occupancy at each point (0% to 100%). I leave two images, the first is my model, the second is how I look for it to remain (this second is taken from a website of my city government).
Also, I need tool tips to display that indicator in percentage format. It has not been possible even though this column I have it in percentage format. But in tool tips it comes out in decimal format, I don't understand why. Likewise, I also want to hide the latitude and longitude fields in the tooltips, but I see no option for it.
Thanks for the help!
This is my model.
That's how I want it to look.
Solved! Go to Solution.
And you can have conditional formatting in the data color option. Please see my sample.
Paul Zheng _ Community Support Team
If this post helps, then consider Accept it as the solution to help other members find it faster.
And you can have conditional formatting in the data color option. Please see my sample.
Paul Zheng _ Community Support Team
If this post helps, then consider Accept it as the solution to help other members find it faster.
@ManuelEspitia , You have set the format from Column/measure tools? Typically that should work with the tooltip. I doubt you can remove lat/long or location information from the tooltip. Use the report tooltip page if needed.
@ManuelEspitia Sorry, having trouble following, can you post sample data as text and expected output?
Need to create a calculated column or disconnected table and measure to put in Legend but unclear what your data looks like.
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882
Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.
The Power BI Data Visualization World Championships is back! It's time to submit your entry.
| User | Count |
|---|---|
| 131 | |
| 118 | |
| 57 | |
| 45 | |
| 43 |