Multiple header in table visualization

[Anonymous]

Hi everyone

i should create a two headers table visualization in Power BI:

	Index 1	Index 2
	123	365
1/1/2020	22,45	25,87

Exporting data from dashboard i should mantain the same format also in excel.

Can you help me?

Thx

Mike

[Daviejoe]

[Daviejoe]

Hi @Anonymous 

Select the Table visual and drop your 3 fields into it.  This should give you what you require.

Unless I'm misunderstanding what you are asking for?

[Anonymous]

Many thanks,

in my database index, code index and period are in row. Using power query i created a pivot column using index and i obtained this:

	Index 1	Index 2
1/1/2020	22,49	25,87

both in excel and in PBI.

To obtain the target solution, i need to add another row and insert code index related to index 1 and index 2 and create another header in table visualization.

In this way i can obtain this and exporting data i can visualize the correct template

	Index 1	Index 2
	123	345
1/1/2020	22,49	25,87

[Daviejoe]

You'll need to explain, a bit more, of what you want to create in this additional row?

Is it only 1 additional row you are looking to create?

[Anonymous]

Yes, because in my data model i have:

ID	Period	Index	Code Index	Value
1	1/1/2020	Index 1	123	22,56
2	1/1/2020	Index 2	345	25,67

Using power query in PBI desktop  i can transpose Index column to obtain 

	Index 1	index 2
1/1/2020	22,56	25,67

but the final result should be 

	Index 1	Index 2
	123	345
1/1/2020	22,56	25,67

I think that to obtain the final result i should transpose also the initial code index column, but i don't know if it is possible.

[Daviejoe · Accepted solution]

I don't think you would be able to create the double header effect I'm afraid.

You could put your second header on as a row header but that will move you away, slightly, from the effect you were looking for.

[Anonymous]

Ok thanks