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