How to show in a pie chart a percentage from two column values

[Orcorcorco]

Hi - Can someone help me with this concern?

I have columns. One is Total Employees and the other is Total Responses.

I want to be able to show a chart that will show me the percentage of Total Responses / Total Employees and not adding a column in the data source anymore.

Illustration:

Total Employees      Total Responses

1000                         900

I wanted to use a pie chart which should look like this.

Thanks

[v-yingjl · Accepted solution]

Hi @Orcorcorco ,

Based on your description, you can create two measures and put them in the values field in Dount chart.

responses = SUM('Table'[Total Responses]) / SUM('Table'[Total Employees]) 

other = (SUM('Table'[Total Employees]) - SUM('Table'[Total Responses])) / SUM('Table'[Total Employees])

Set the Label style as 'Percent of Total' and Label position as 'Inside' under Detail labels menu, you will get your expected result:

left is a pie chart, right is a dount chart

Best Regards,
Yingjie Li

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Orcorcorco , In pie visual you have option Label Style, You can choose Percent of Total and position inside.

do not drag any legend or details. only use measures under "values".

You can refer

https://www.goskills.com/Microsoft-Office/Articles/Power-BI-pie-chart

[calerof]

Hi @Orcorcorco,

If  a dataset like the following is your case

You could use this measure:

EmployeeResponded = 
CALCULATE( COUNT(ResponseRate1[Response]), ResponseRate1[Response] = 1)

 And another for negative responses, and you would get something like this:

Hope it helps.

Regards,

Fernando