hello,

I am trying to create a facility criticality dashboard that will use shapefiles. Does anybody have experience on this?

What I was hoping to do with the shapefile is to be able to change the color of the line or segment (e.g. pipeline) depending on the flow scenario. If the facility is in a "high critical" scenario the color will be red, and if in "low critical" scenario it will be green.

I am new to PowerBi and GIS so I will struggle even the terminologies.

Thanks in advance for your help.

Alan

Great question, Alan - you're definitely thinking in the right direction by connecting asset criticality visualization with spatial awareness. 🔍

Here's how you can approach it step by step:

1. Prepare Your Shapefile Data

   • Ensure your shapefile (e.g., pipelines, facilities) includes a unique identifier like facility_id or asset_id.

   • You'll use this field to join your shapefile data with your criticality or flow scenario table in Power BI.

2. Use Power BI's Shape Map or ArcGIS Visual

   • The Shape Map visual in Power BI can handle shapefiles once converted to TopoJSON format (you can use tools like mapshaper.org for that).

   • Alternatively, try the ArcGIS for Power BI visual - it's more GIS-friendly and lets you apply conditional color rules dynamically.

3. Color by Criticality

   • After joining your data tables, create a DAX measure or calculated column for criticality (e.g., "High," "Medium," "Low").

   • Then set the color scale or conditional formatting in your map visual: red for high, yellow for medium, green for low.

4. Pro Tip

   • If your organization uses Maximo Spatial or Maximo Application Suite (Manage + Map), you can export spatial data directly from Maximo with criticality attributes - which makes this integration cleaner and more automated.

Don't worry about being new to Power BI or GIS - you're already tackling the hardest part: thinking about how to tell the story visually. 👍

- Manu Nagayach
IBM-Certified Maximo Architect | EAM Strategist
#maximo #powerbi #gis #eam #assetmanagement #visualanalytics