Total workingdays by subgroup

[danielkari]

Hi! Let's say I have the following table

City | State

Dallas | TX
Houston | TX
Austin | TX

Atlanta | GA

Oklahoma City | OK

Is it possible to color scatter points (cities) by state? Like red for Texas etc. 

[v-yuta-msft · Accepted solution]

Hi danielkari,

You may create a map visual and drag [State] colunmn into legend field and drag [City] column into Location field like below:

 

Regards,

Jimmy Tao

[quentin_vigne]

Hi @danielkari

I think you can only do that in a Matrix with conditionnal formating but not on a map

- Quentin