Power Bi Report-Visual

[Deus_Kapinga]

Hi Everyone,

Can I get your support? I want to draw a donut/pie chart, but the labels I want to be the percentage of the total, and the values to be from another cell column. For example, in the data below, I want the data labels to be the percentage of the total of the CYP and the values to be from the Number of Items, as shown in the pie chart below.

Product Name	Number of Items	CYP
Condoms	44089	367
implants	2627	8206
IUCD	328	1509
Vasectomy	27	330

Regards,

Deus

[Deus_Kapinga]

@bhanu_gautam, thank you for your support. I have worked as you have guided. However, during formatting, I can't see the "Turn on the 'Percentage' option to show the percentage of the total CYP." These are the only options available in the Detail labels.

I will appreciate your support. 

[bhanu_gautam · Accepted solution]

@Deus_Kapinga 

Create a new measure for the percentage of total CYP:

DAX
Percentage of Total CYP =
DIVIDE(
SUM('YourTableName'[CYP]),
CALCULATE(SUM('YourTableName'[CYP]), ALL('YourTableName'))
)

In the Visualizations pane, select the Donut chart or Pie chart icon.
Drag the "Product Name" field to the "Legend" area.
Drag the "Number of Items" field to the "Values" area.
Drag the "Percentage of Total CYP" measure to the "Tooltips" area.

Click on the chart to select it.
In the Visualizations pane, go to the "Format" section (paint roller icon).
Expand the "Detail labels" section.
Set the "Label style" to "Data value".
Turn on the "Percentage" option to show the percentage of the total CYP.