Create a precentage donut view

[mathician]

So im trying to create a donut chart that shows the precentage of opened email. Like this(img). I want it to highlight just opening precentage. So in this case 20.88%

The problem is my data looks like this. First how can change this to % and how can i highlight just the email opening of totalt email sent.

Emails sent:	Id person:	Date opened:	Email_opened
1:	46:	20.08.20:20:05:06:	1
1:	33:	20.08.20:20:05:06:	0

[Anonymous · Accepted solution]

Hi @mathician ,

Create a visual as below, "email opened" as legend, count of "id person" as value. Then edit the Data colors under Format pane.

Best Regards,

Jay

[MFelix]

Hi @mathician ,

If you place on the legend the E-mail opened column then you just need to change the colors of different parts:

If you want the card make a measure similar to this one:

Count of ID weighted by Count of Opened per Opened = 
CALCULATE(COUNT('Table (2)'[ID]), 'Table (2)'[Opened] = 1) / COUNT('Table (2)'[ID])

Check PBIX file attach and also check my blogpost about this type of custom formatting.

https://community.powerbi.com/t5/Community-Blog/Think-inside-the-box-Custom-visuals-using-Standard-V...

[mathician]

when i try it, it comes with this.

[MFelix]

Hi @mathician ,

On values place the count of ID and on legend place the e-mail open closed.

[amitchandak]

@mathician , Not very clear. In donut, you have the option to display percent.