How(Using which visual) to show part/division data with total data?

[j_w]

The desired visual is something like this:

The Total data could be generated by using a separate label, but it would be nice if the visual itself could do this.

Thanks.

[v-yuezhe-msft · Accepted solution]

Hi @j_w,

Could you please share us sample data？

If you have Name and Qty columns in your table, just create a pie chart in Power BI Desktop as shown in the following screenshot. Drag Qty column toValues section,  drag Other column to Tooltips section.

Then add a textbox as shown in the following screenshot.

Thanks,
Lydia Zhang

[j_w]

@v-yuezhe-msft  Hi Lydia, is there a visual that could show the Total info without adding an additional label? Thanks.

[v-yuezhe-msft]

Hi @j_w,

You can create a measure to calculate total qty, then drag the measure to a card visual.


Thanks,
Lydia Zhang