Display data in tabular form as percentages

[wizberg]

Hi folks, I am trying to display my data from various rows into a table form in PowerBI visual. Basically my data table looks like this:

Date	John	Mary	Robert
1-Jan	ON TIME	LATE	LATE
2-Jan	ON TIME	LATE	LATE
3-Jan	ON TIME	LATE	LATE
4-Jan	ON TIME	ON TIME	ON TIME
5-Jan	LATE	ON TIME	ON TIME
6-Jan	ON TIME	ON TIME	ON TIME
7-Jan	ON TIME	ON TIME	ON TIME
8-Jan	ON TIME	ON TIME	ON TIME
9-Jan	ON TIME	LATE	ON TIME
10-Jan	LATE	LATE	LATE
11-Jan	LATE	LATE	LATE
12-Jan	LATE	ON TIME	ON TIME
13-Jan	LATE	ON TIME	ON TIME
14-Jan	LATE	ON TIME	ON TIME
15-Jan	ON TIME	LATE	ON TIME
16-Jan	ON TIME	LATE	ON TIME
17-Jan	ON TIME	LATE	ON TIME

I want to display it as a summarised table showing like below:

	John	Mary	Robert
On TIME	64.7%	47.1%	71%
LATE	35.3%	52.9%	29%

I just cannot seemed to get it out via the Visualiation charts in Power BI desktop. Any good advice? Thanks!

[camargos88 · Accepted solution]

Hi @wizberg ,

I've create this file as an example: Download PBIX 

Ricardo