March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe 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
Greetings,
I have the following data:
NAME | G3E_FID | Y_GOOGLE | X_GOOGLE | SEQ | POLYGON_TYPE |
FASK036 | 135921674 | 32.21719657 | 35.2976983 | 0 | FCABINET |
FASK036 | 135921674 | 32.21778272 | 35.29706794 | 1 | FCABINET |
FASK036 | 135921674 | 32.21770841 | 35.29620753 | 3 | FCABINET |
FASK036 | 135921674 | 32.21719124 | 35.2959154 | 4 | FCABINET |
FASK036 | 135921674 | 32.21748347 | 35.29481467 | 6 | FCABINET |
FASK036 | 135921674 | 32.21650881 | 35.29402256 | 7 | FCABINET |
FASK036 | 135921674 | 32.2161277 | 35.29504675 | 8 | FCABINET |
FASK036 | 135921674 | 32.2146214 | 35.29486696 | 10 | FCABINET |
FASK036 | 135921674 | 32.21461368 | 35.29479057 | 11 | FCABINET |
FASK036 | 135921674 | 32.21347036 | 35.29435621 | 13 | FCABINET |
FASK036 | 135921674 | 32.21339364 | 35.29467502 | 14 | FCABINET |
FASK036 | 135921674 | 32.21323203 | 35.29534656 | 15 | FCABINET |
FASK036 | 135921674 | 32.21292649 | 35.29652581 | 17 | FCABINET |
FASK036 | 135921674 | 32.21282628 | 35.29689479 | 18 | FCABINET |
FASK036 | 135921674 | 32.21267028 | 35.29841845 | 20 | FCABINET |
FASK036 | 135921674 | 32.21308761 | 35.29852856 | 21 | FCABINET |
FASK036 | 135921674 | 32.21363955 | 35.29870383 | 22 | FCABINET |
FASK036 | 135921674 | 32.21559398 | 35.29720221 | 24 | FCABINET |
FASK036 | 135921674 | 32.21719657 | 35.2976983 | 25 | FCABINET |
FASK036 | 135921674 | 32.21778573 | 35.29662786 | 2 | FCABINET |
FASK036 | 135921674 | 32.21738786 | 35.29528267 | 5 | FCABINET |
FASK036 | 135921674 | 32.21582091 | 35.29587118 | 9 | FCABINET |
FASK036 | 135921674 | 32.21428884 | 35.29473158 | 12 | FCABINET |
FASK036 | 135921674 | 32.21312263 | 35.29580114 | 16 | FCABINET |
FASK036 | 135921674 | 32.21258932 | 35.29783551 | 19 | FCABINET |
FASK036 | 135921674 | 32.21481686 | 35.29927945 | 23 | FCABINET |
I want to display polygons on the map based on list of Longitude and Latitude as appears on this image:
I tried Filled map and arcGIS map, but it doesn't fit my needs, any suggestions please?
Regards.
Solved! Go to Solution.
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.
See here for another example:
https://www.icon-map.com/usage_shapes.html#wkt
Regards,
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.
See here for another example:
https://www.icon-map.com/usage_shapes.html#wkt
Regards,
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
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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
128 | |
90 | |
75 | |
56 | |
53 |
User | Count |
---|---|
200 | |
104 | |
101 | |
67 | |
55 |