Combining Multiple Measures into a Unified Pie Chart Overlay on Power BI Map

[condale737]

Hello Power BI community!

I have measures for sales, gains, and losses. I aim to display their aggregate in a pie chart overlay on a map (power bi default map - not Azure Map), segmented by measure type. I have the location set on town name and it works fine but I just need the measure to show in one bubble. Essentially, the measures would be in the legend and the value. For instance, a town might display 25M in sales, 21M in gains, and 12M in losses. While I can visualize each measure independently on the map and segment with a dimension column in the legend, I need a unified view for all three measures that is segmented by the measure type. How can I achieve this with the measure as the dimension in Power BI?

I believe I am looking for a calculated table with a switch statement, but I am not sure.

[lbendlin]

A pie chart is the wrong visual for that set of data. A waterfall chart may be more appropriate, or a simple table.

Read about custom tooltip pages.