https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Combining-Multiple-Measures-into-a-Unified-Pie-Chart-Overlay-on/m-p/3476909#M132828 <P class="">Hello Power BI community!<BR /><BR />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?<BR /><BR /></P><P class="">I believe I am looking for a calculated table with a switch statement, but I am not sure.</P> Sat, 14 Oct 2023 16:06:48 GMT condale737 2023-10-14T16:06:48Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Combining-Multiple-Measures-into-a-Unified-Pie-Chart-Overlay-on/m-p/3476909#M132828 <P class="">Hello Power BI community!<BR /><BR />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?<BR /><BR /></P><P class="">I believe I am looking for a calculated table with a switch statement, but I am not sure.</P> Sat, 14 Oct 2023 16:06:48 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Combining-Multiple-Measures-into-a-Unified-Pie-Chart-Overlay-on/m-p/3476909#M132828 condale737 2023-10-14T16:06:48Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Combining-Multiple-Measures-into-a-Unified-Pie-Chart-Overlay-on/m-p/3492518#M133743 <P>A pie chart is the wrong visual for that set of data. A waterfall chart may be more appropriate, or a simple table.</P> <P>&nbsp;</P> <P>Read about custom tooltip pages.</P> Mon, 23 Oct 2023 22:58:53 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Combining-Multiple-Measures-into-a-Unified-Pie-Chart-Overlay-on/m-p/3492518#M133743 lbendlin 2023-10-23T22:58:53Z