@RichardLinderma Hi! The issue you’re facing with the Flow Map visual in Power BI is likely due to how the tooltip context is being generated. Since the Flow Map inherently deals with connections between locations, it is displaying the breakdown per destination rather than aggregating the total values per origin.
Solution: Using a Custom Tooltip Page
Instead of relying on the default tooltip behavior, you can create a custom tooltip page that displays the aggregated data for the selected origin. Here’s how to do it:
1. Create a Tooltip Page
1. Go to Report View in Power BI.
2. Click on New Page, then rename it to something like TooltipPage.
3. In the Format Pane (for the page), set:
- Page Size → Tooltip.
- Allow Tooltip → On.
- Keep the page hidden so it doesn’t show in navigation.
2. Add a Table or Card Visualization
On the tooltip page:
- Insert a Table visual (or a series of Cards).
- Add the Origin Country field.
- Create and add aggregated measures for PAX Count, Spend, and Avg Fare.
For example, define the following measures in DAX:
Total PAX Count = SUM('Table'[PAX Count])
Total Spend = SUM('Table'[Spend])
Avg Fare = DIVIDE([Total Spend], [Total PAX Count], 0)
Then, arrange them in the visual so that they appear in the format you want.
3. Assign the Tooltip Page to the Flow Map
1. Select the Flow Map visual.
2. Go to the Format Pane → Expand the Tooltip section.
3. Set Type to Report Page.
4. Select TooltipPage from the dropdown.
BBF
