Customized header grouped on 2 lines

[Linxys]

Hi guys, I want to reproduce something like that in a matrix:

Buet my yitles are made by hand in Excel but I want to avoir any manipulation in Excel, any solution ?

Thanks !

[Linxys]

Data look like this :

CODE_RSS	Établissement	DOMICILE	CH	Ri-RTF	AUTRES	CHSLD
	Total	640	633	182	116	246
a	abc	239	173	68	44	26
b	def	168	271	62	10	67
c	ghi	138	176	20	14	36
d	jkl	77	60	14	18	50
e	mno	55	71	9	4	5
f	pqr	54	16	12	7	64
g	stu	46	54	14	4	36

[Anonymous]

This You can achieve with the help of data modeling and custom table

To achieve this Your data should look like as below. Then with the help of swith dax measure you can pass your result.

[Linxys]

My data look more like this :

CODE_RSS	Établissement	DOMICILE	CH	Ri-RTF	AUTRES	CHSLD
	Total	640	633	182	116	246
a	abc	239	173	68	44	26
b	def	168	271	62	10	67
c	ghi	138	176	20	14	36
d	jkl	77	60	14	18	50
e	mno	55	71	9	4	5
f	pqr	54	16	12	7	64
g	stu	46	54	14	4	36

[Linxys]

bump

[foodd]

The following guidance on working with Matric Visuals is helpful:

• https://www.burningsuit.co.uk/blog/2019/04/7-secrets-of-the-matrix-visual/
• https://docs.microsoft.com/en-us/power-bi/visuals/desktop-matrix-visual

[Linxys]

Doesn't really help me, my data is all in columm and the title cannot be set autoaticly but will be static in my visual.