Forum Discussion

j_w's avatar
j_w
Helper IV
9 years ago
Solved

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

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.

Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    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

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    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's avatar
      j_w
      Helper IV
      9 years ago

      Anonymous  Hi Lydia, is there a visual that could show the Total info without adding an additional label? Thanks.

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        Hi j_w,

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


        Thanks,
        Lydia Zhang