Forum Discussion
How to Pivot Table After Exporting Data from app.powerbi.com
Hello Community,
With the help of amitchandak I managed to Export Data from app.powerbi.com to Excel. I am now using the following link to get the columns in table format (I think it is called Pivoting). I'm using the following link as a guide.
https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-analyze-in-excel
I'm at the stage shown in the screenshot below, but I'm not sure what to do from here. I basically want to export the fields in the spreadsheet in normal header / row format. Can someone let me know how to go about that. I'm sure its quite straightforward
Thanks
Hi carlton7372 ,
I found the following article :
Create a PivotTable to analyze worksheet data - Microsoft Support
Article on how to create a pivot table in excel, changing the design of a pivot table by adding and arranging its fields.The Field List has a field section in which you pick the fields you want to show in your PivotTable, and the Areas section (at the bottom) in which you can arrange those fields the way you want.
Best Regards,
Wenbin Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 Replies
Just for further clarification I would like to get re-pivot the table so that spreadsheet looks like
Hi carlton7372 ,
Regarding your question, you can place the fields in the table in 'Values', the values are automatically aggregated.
If you want to analyze the values further, you can add the fields that are used as filters to the 'Rows '.
Best Regards,
Wenbin Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.Can I get some help with this please
Hi carlton7372 ,
I found the following article :
Create a PivotTable to analyze worksheet data - Microsoft Support
Article on how to create a pivot table in excel, changing the design of a pivot table by adding and arranging its fields.The Field List has a field section in which you pick the fields you want to show in your PivotTable, and the Areas section (at the bottom) in which you can arrange those fields the way you want.
Best Regards,
Wenbin Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
