Forum Discussion

Resolver's avatar
Resolver
New Member
1 year ago

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

  • johnbasha33's avatar
    johnbasha33
    Super User
    1 year ago

    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 !!