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.
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