Forum Discussion

saranedal's avatar
saranedal
Frequent Visitor
4 years ago

Floor Plan Visual by Simpson Associates

hello 
I have downloaded the sample of the floor Plan Visual by Simpson Associates, but the problem is when trying to understand the MULTIPOLYGON I am unable to achieve that, any idea how I can find a resource to do my own MULTIPOLYGON

thank you

2 Replies

  • v-jingzhang's avatar
    v-jingzhang
    Icon for Community Support rankCommunity Support

    Hi saranedal 

     

    The MULTIPOLYGON data in that sample file is imported from an Excel file and the Points String column is of Text type. It means that you need to define MULTIPOLYGON data of every element in advance in a table outside of Power BI. 

     

    Every MULTIPOLYGON is composed of one or multiple POLYGONs. For every POLYGON, you need to define the (X Y) coordinates of every point. And the last point should be the first point so that it draws a complete polygon. 

     

    You may refer to the following docs about MULTIPOLYGON and POLYGON.

    MultiPolygon - SQL Server | Microsoft Docs

    Polygon - SQL Server | Microsoft Docs

     

    Best Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as Solution to help other members find it.