Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
rawandshoraa
Frequent Visitor

Display Polygons based on list of (X,Y)

Greetings,

I have the following data: 

NAMEG3E_FIDY_GOOGLEX_GOOGLESEQPOLYGON_TYPE
FASK03613592167432.2171965735.29769830FCABINET
FASK03613592167432.2177827235.297067941FCABINET
FASK03613592167432.2177084135.296207533FCABINET
FASK03613592167432.2171912435.29591544FCABINET
FASK03613592167432.2174834735.294814676FCABINET
FASK03613592167432.2165088135.294022567FCABINET
FASK03613592167432.216127735.295046758FCABINET
FASK03613592167432.214621435.2948669610FCABINET
FASK03613592167432.2146136835.2947905711FCABINET
FASK03613592167432.2134703635.2943562113FCABINET
FASK03613592167432.2133936435.2946750214FCABINET
FASK03613592167432.2132320335.2953465615FCABINET
FASK03613592167432.2129264935.2965258117FCABINET
FASK03613592167432.2128262835.2968947918FCABINET
FASK03613592167432.2126702835.2984184520FCABINET
FASK03613592167432.2130876135.2985285621FCABINET
FASK03613592167432.2136395535.2987038322FCABINET
FASK03613592167432.2155939835.2972022124FCABINET
FASK03613592167432.2171965735.297698325FCABINET
FASK03613592167432.2177857335.296627862FCABINET
FASK03613592167432.2173878635.295282675FCABINET
FASK03613592167432.2158209135.295871189FCABINET
FASK03613592167432.2142888435.2947315812FCABINET
FASK03613592167432.2131226335.2958011416FCABINET
FASK03613592167432.2125893235.2978355119FCABINET
FASK03613592167432.2148168635.2992794523FCABINET

 

 

I want to display polygons on the map based on list of Longitude and Latitude as appears on this image:

rawandshoraa_0-1724157393970.png

 

 

I tried Filled map and arcGIS map, but it doesn't fit my needs, any suggestions please? 

 

Regards. 

1 ACCEPTED SOLUTION
OwenAuger
Super User
Super User

Hi @rawandshoraa 

Icon Map may be a good option for this - PBIX example attached using your data.

I created a measure Polygon that concatenates the coordinates to create a WKT Polygon:

Polygon = 
IF (
    HASONEVALUE ( Data[NAME] ), -- Create Polygon for single Name only
    VAR PointList =
        CONCATENATEX (
            Data,
            Data[X_GOOGLE] & " " & Data[Y_GOOGLE],
            ",",
            Data[SEQ]
        )
    VAR Result =
        "POLYGON((" & PointList & "))"
    RETURN
        Result
)

There are various formatting options and other details you will likely need to sort out, but hopefully this method is workable for you.

OwenAuger_0-1724164778603.png

See here for another example:

https://www.icon-map.com/usage_shapes.html#wkt

 

Regards,


Owen Auger
Did I answer your question? Mark my post as a solution!
Blog
Twitter
LinkedIn

View solution in original post

3 REPLIES 3
OwenAuger
Super User
Super User

Hi @rawandshoraa 

Icon Map may be a good option for this - PBIX example attached using your data.

I created a measure Polygon that concatenates the coordinates to create a WKT Polygon:

Polygon = 
IF (
    HASONEVALUE ( Data[NAME] ), -- Create Polygon for single Name only
    VAR PointList =
        CONCATENATEX (
            Data,
            Data[X_GOOGLE] & " " & Data[Y_GOOGLE],
            ",",
            Data[SEQ]
        )
    VAR Result =
        "POLYGON((" & PointList & "))"
    RETURN
        Result
)

There are various formatting options and other details you will likely need to sort out, but hopefully this method is workable for you.

OwenAuger_0-1724164778603.png

See here for another example:

https://www.icon-map.com/usage_shapes.html#wkt

 

Regards,


Owen Auger
Did I answer your question? Mark my post as a solution!
Blog
Twitter
LinkedIn

Thanks for your help.

 

i want to add another layer to the map which present the center of the polygon, based on specified x,y. 
where to add the new layer? there is no option to add another layer?!! 

 

Thanks in advance 

Hi @rawandshoraa 

I had a quick look. The free version of Icon Map unfortunately appears not to support multiple layers such as a dot on top of the polygon layer 😞

 

Icon Map Pro (paid version) does sound like it supports this though.

 

There could be some possibilities with the Azure Map visual which you may want to experiment with, but I'm not that familiar with it.


Owen Auger
Did I answer your question? Mark my post as a solution!
Blog
Twitter
LinkedIn

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.