Map Visuals from Coordinates from Different columns

[Jagan_MFilterIT]

Hi, 

We have a requirement where are needed to create a map visual from coordinates from different columns. To explain this further:

We have a location of a restaurant in one set of the columns (Kitchen Lat and Kitchen Long) that belogs to a specific restaurant. Now we search for this restaurant in an app from different locations(Scan lat and scan long) and get the ranking. 

Not the requirement is to show both Kitchen location and scan locations in a single map visual and also show the rankings for scan location either as a bubble or in some color form. Is there a way to do it? 

[Anonymous · Accepted solution]

Hi @Jagan_MFilterIT,

AFAIK, power bi map visual does not support using two groups of lat/long at the same time.
Perhaps you can do pivot on the fields to convert them to attribute and value, then you can use them in your visual. For color formatting, you can put the rank field of legends to manually configure the rank colors.

Unpivot columns (Power Query) (microsoft.com)

Regards,

Xiaoxin Sheng