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

July 28 - August 9 | Final Round of the Power BI Dataviz World Championships. This is your chance. Learn more

Reply
Resolver
New Member

Flow map route error

Hello, I've created a flow map for displaying top n routes by order count. The problem is that not all routes are visible on map. For data I am using city, state, country and zip code, all locations were checked on map and there were no error with data itself, but whenever I put it as a full route in flow map, some and even top 2 lanes are not displayed.

1 REPLY 1
johnbasha33
Super User
Super User

@Resolver 

1.Double-check your Top N calculation outside the map first.

  • Create a separate table visual showing exactly which Source-Destination pairs and counts are top.

  • Ensure that Flow Map is getting exactly those pairs.

2. Try to simplify the geography a bit.

  • Use City + Country or State + Country only.

  • Sometimes adding Zip Codes confuses the geocoding engine and causes routes to disappear.

3. Lower the Top N if possible.

  • Try Top 20 or Top 50 first.

  • Flow Map can choke if you push too many routes at once.

4. Check for duplicates or rounding issues.

  • If two routes have almost the same counts, and you have a Top N filter, sometimes minor rounding can push the expected routes out.

5. Try using Source Latitude/Longitude and Destination Latitude/Longitude directly.

  • If you can add lat/lon to your data, you bypass some of the geocoding guesswork.

6. Adjust settings inside the Flow Map visual

  • There is often an option like:

    • "Route smoothing"

    • "Avoid overlapping lines"

    • "Force show all routes" (depends on the visual version)

7. (Last resort) Use an alternative visual

  • If Flow Map keeps failing, try the Route Map custom visual or even ArcGIS for Power BI.

They're heavier but more reliable for lots of paths.

Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!

Helpful resources

Announcements
FabCon and SQLCon Barcelona 2026

FabCon & SQLCon – Barcelona 2026

Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.

Fabric Community Sticker Design Challenge Barcelona Carousel

Fabric Community Sticker Challenge - Barcelona 2026

If you love stickers, then you will definitely want to check out our community sticker challenge, Barcelona edition!

July Power BI Update Carousel

Power BI Monthly Update - July 2026

Check out the July 2026 Power BI update to learn about new features.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.