Forum Discussion

Frequent Visitor

3 years ago

Solved

County and Numerical Labels in ArcGIS Map Visual | Power BI

Hello, I am fairly new to expermenting with arcGIS on Power BI and I was hoping to get some help. I am looking for a way to show a County color coded map based on the Number of Applications, and ...

Need Help

Anonymous
3 years ago
Hi escarzl1

You can also create a color measure, then put the measure to the color field

e.g

Measure = SWITCH(TRUE(),SELECTEDVALUE('Table'[Country])="Pierce","Green",SELECTEDVALUE('Table'[Country])="King","Red")

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

escarzl1

Frequent Visitor

3 years ago

UPDATE:

I modified the Map Labels calculated column like this:

MapLabels = 
'Table'[County]&"
"&CALCULATE(SUM('Table'[Count of Applications]), ALLEXCEPT('Table','Table'[Agency],'Table'[County]))

I insterted the [MapLabels] in the tooltip and used the tooltip as a label in the map settings:

This seemed to work when I filter the map by certain Agencies, but not by every Agency.

Example 1: The numbers on the table on the left add up to the numbers on the Map

Example 2: I selected a different Agency in the filter and the numbers on the table don't add up to what is shown in the Map

Can someone help me understand what can be fixed on my [MapLabels] calculation?