Matrix Visual in Power BI

[shansakhi]

Hello All,
I am trying to you Matrix visual to show data like below.
Just to give an overview:
Date is comming from date table
BKD_6W, BKD_13W, SF_6W, SF_13W comming from Table 1 - There are all measures
Rest Alphabets from A until Z are comming from Table 2 - There are in one Column called Class

When I am trying to build Matrix visual for every alphabet 5 columns get added.

I need out put as below:

Book1
	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH	AI	AJ
3	Date Table	Source: Table 1				Source: Table 2
4	Date	BKD_6W	BKD_13W	SF_6W	SF_13W	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z
5	13-Aug-24	81%	82%	85%	89%	1	3	5	7	9	11	13	15	17	19	21	23	25	27	29	31	33	35	37	39	41	43	45	47	49	51
6	14-Aug-24	82%	83%	86%	90%	2	4	6	8	10	12	14	16	18	20	22	24	26	28	30	32	34	36	38	40	42	44	46	48	50	52
7	15-Aug-24	83%	84%	87%	91%	3	5	7	9	11	13	15	17	19	21	23	25	27	29	31	33	35	37	39	41	43	45	47	49	51	53
8	16-Aug-24	84%	85%	88%	92%	4	6	8	10	12	14	16	18	20	22	24	26	28	30	32	34	36	38	40	42	44	46	48	50	52	54
9	17-Aug-24	85%	86%	89%	93%	5	7	9	11	13	15	17	19	21	23	25	27	29	31	33	35	37	39	41	43	45	47	49	51	53	55
10	18-Aug-24	86%	87%	90%	94%	6	8	10	12	14	16	18	20	22	24	26	28	30	32	34	36	38	40	42	44	46	48	50	52	54	56
11	19-Aug-24	87%	88%	91%	95%	7	9	11	13	15	17	19	21	23	25	27	29	31	33	35	37	39	41	43	45	47	49	51	53	55	57
12	20-Aug-24	88%	89%	92%	96%	8	10	12	14	16	18	20	22	24	26	28	30	32	34	36	38	40	42	44	46	48	50	52	54	56	58
13	21-Aug-24	89%	90%	93%	97%	9	11	13	15	17	19	21	23	25	27	29	31	33	35	37	39	41	43	45	47	49	51	53	55	57	59
14	22-Aug-24	90%	91%	94%	98%	10	12	14	16	18	20	22	24	26	28	30	32	34	36	38	40	42	44	46	48	50	52	54	56	58	60
15	23-Aug-24	91%	92%	95%	99%	11	13	15	17	19	21	23	25	27	29	31	33	35	37	39	41	43	45	47	49	51	53	55	57	59	61
Sheet1

Regards,
Shan

 

[Matt Allington]

Yes, it’s a limitation. If you do this in an Excel Pivot table, you can use “Fields, Items and Sets” to do what you want (build an asymmetrical table). In Power BI it is not so easy. You either need to build an asymmetrical table manually (I wrote about that here Building a Matrix with Asymmetrical Columns and Rows in Power BI), or use a third party visual such as InfoRiver.

 

[shansakhi]

Thank you, Matt. I will go through your blog and come back to you if any query.