March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
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
Solved! Go to 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.
Proud to be a Super User!
Proud to be a Super User!
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?
Proud to be a Super User!
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?
Proud to be a Super User!
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.
Proud to be a Super User!
Ok thanks
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
User | Count |
---|---|
90 | |
89 | |
85 | |
73 | |
49 |
User | Count |
---|---|
169 | |
144 | |
90 | |
70 | |
58 |