Forum Discussion
Create a precentage donut view
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 |
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
5 Replies
mathician , Not very clear. In donut, you have the option to display percent.
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.
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
