Forum Discussion
Multiple header in table visualization
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.
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 |
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?
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.
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.
Ok thanks