help with creating a table

[Anonymous]

Hello, I would like to create a table exactly like this one in Power bi. This table comes from Excel. I'm having issues

formatting the table so each row category is divided in two, for example code 1 has the count value 1 and then the percentage of CUB which is 7.14%. 

I also want to format the dates like on this table. Please let me know if this will be possible in Power bi.

Any help will be much appreciated.

Best,

LELI

Top 5 Issue Codes	18-Aug	18-Sep	18-Oct	18-Nov	18-Dec	19-Jan	19-Feb	19-Mar	19-Apr	19-May	19-Jun	19-Jul	Total	% of total	% of CUB	Average
code 1	1	3	4	12	10	12	22	24	45	40	44	63	280	24.24%		23.33
7.14%	13.64%	13.79%	21.43%	12.20%	8.11%	13.02%	10.00%	14.85%	7.97%	6.12%	7.88%
code 2	4	3	2	9	11	9	15	23	31	41	40	48	236	20.43%		19.67
28.57%	13.64%	6.90%	16.07%	13.41%	6.08%	8.88%	9.58%	10.23%	8.17%	5.56%	6.00%
code 3	11	2	2	5	5	15	10	22	70	30	34	14	220	19.05%		18.33
78.57%	9.09%	6.90%	8.93%	6.10%	10.14%	5.92%	9.17%	23.10%	5.98%	4.73%	1.75%
code 4	3	6	4	6	3	6	11	15	32	42	28	57	213	18.44%		17.75
21.43%	27.27%	13.79%	10.71%	3.66%	4.05%	6.51%	6.25%	10.56%	8.37%	3.89%	7.13%
code 5	4	2	0	2	6	5	9	10	31	30	62	45	206	17.84%		17.17
28.57%	9.09%	0.00%	3.57%	7.32%	3.38%	5.33%	4.17%	10.23%	5.98%	8.62%	5.63%
Total	23	16	12	34	35	47	67	94	209	183	208	227	1155	100%		96.25
% of total	1.99%	1.39%	1.04%	2.94%	3.03%	4.07%	5.80%	8.14%	18.10%	15.84%	18.01%	19.65%
CUB	14	22	29	56	82	148	169	240	303	502	719	800
% of CUB	164.29%	72.73%	41.38%	60.71%	42.68%	31.76%	39.64%	39.17%	68.98%	36.45%	28.93%	28.38%

[Anonymous]

Hi @Anonymous ,

You can try this by using a Matrix instead of Table Visualization.

( if possible give us a sample data so that we know how your data looks like)

Also for the date you can try this.

1. select the date field 2.

2. Go to modeling .

3.and in the format dropdown you can select the date you want.

(screenshot below for your refernce)

Let me know if this works.

Thanks,

Tejaswi