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
Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.
Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!
User | Count |
---|---|
226 | |
54 | |
43 | |
43 | |
42 |
User | Count |
---|---|
275 | |
211 | |
75 | |
73 | |
64 |