Forum Discussion
Pivot table in power query
hello, there is a help to make the Pivot table in the picture in a power query.
Picture of the table below. It will make the job much easier and simpler in a situation like the first picture.
ThisWorkbook.Connections("Combined_Financials_Sector").Refresh
note that Background refresh option should be checked. In the Excel UI, you can access this setting by clicking on "Connections" in the "Data" ribbon, selecting a connection, and clicking on "Properties". The "Enable background refresh" setting is in the dialog box that opens.
16 Replies
Anonymous- Check this PBIX file out. Let me know if this works for you.
As rubayatyasmin suggested, you can accomplish this by utilizing the Matrix visuals. In the attached file, you'll find the specific steps that were followed. Moreover, you can reach the same outcome by deactivating the SteppedLayout and adopting the classic style.
Hi Manoj_Nair
This is not the Result I want.
in the Template below.
Can this result be done with the power query in excel?To my knowledge, you can not achieve the same result in PQ.
I am curious if it's possible. Let me know here if you are able to accomplish it in PQ. Maybe some advanced M code can do the trick.
Hi, Anonymous
this is what I could achieve in PQ
though not an exact pivot table like Excel. You could use Power BI matrix visual as an alternative to the Excels pivot table.
