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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
mbbozzuto
Helper II
Helper II

"Shape Map Visual" preview feature not quite there

Hi - we have done some testing on the new "Shape Map Visual" preview feature.  Better mapping capabilities is a must have feature of Power BI.  But based on this current feature, it still misses the mark.  We have our own custom shapes that we can define in GeoJSON or WKT.

 

The way the feature is set now, to create a custom shape definition, we would need to load in the shapes to the visual settings and then that becomes a static layout.  However, our shape definitions can change due to back-end re-designs that flow through our data warehouse.  Based on this feature, we would need to re-load custom shape definitions into Power BI manually.

 

It would be preferred that the shape map could be built from a Dataset column field storing GeoJSON objects so that the shapes could respond dynamically in the visual.

1 ACCEPTED SOLUTION
foodd
Super User
Super User

Please consider turning this post relating to enhancements to one or more Visuals into

a new Idea for consideration at https://ideas.fabric.microsoft.com/.

View solution in original post

4 REPLIES 4
Benton
Frequent Visitor

"It would be preferred that the shape map could be built from a Dataset column field storing GeoJSON objects so that the shapes could respond dynamically in the visual." We agree, this would be the ideal scenario for storing WKT in a table in the data model. The text field length is a limitation for complex geometry with lots of vertices; it gets truncated. Hopefully, Microsoft will consider updating the max length or consider a "geometry" data type similar to SQL Server. I'll ask my team members if they have a post on here that could be upvoted for this feature request.

 

If it's of interest, our EasyTerritory web app can be used to manage and edit GeoJSON, and we have an API that can be called to get the GeoJSON to load into your data warehouse. We also have a data connector for PBI that pulls a lookup table into the PBI data model and the geometry into our Azure Maps-based Territory Visual through a primary key at runtime. This allows you to update your shapes and then use the approach for refreshing your data model.

 

Benton (from EasyTerritory)

- Sorry in advance for over posting, we're excited about bringing advanced mapping capabilities in Power BI!

Looks cool, will check it out.  Thanks.

foodd
Super User
Super User

Please consider turning this post relating to enhancements to one or more Visuals into

a new Idea for consideration at https://ideas.fabric.microsoft.com/.

Will do.  I posted here to see in part as well if someone had a workaround or if I was missing something about the feature.

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors