Forum Discussion

Jagan_MFilterIT's avatar
Jagan_MFilterIT
Icon for Helper I rankHelper I
4 years ago
Solved

Map Visuals from Coordinates from Different columns

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 ...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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