Power Pivot Drill column problem

Question

Dear Sir/ma'am

I have a problem arranging the data after drill down from the power pivot table. The issue is the columns are re-ordered automatically different to the original data. Please suggest how I can keep the original column order.

Result:

Query1[AInt]	Query1[Available_Bal]	Query1[Balance]

Desired Original order:

Query1[Balance]	Query1[AInt]	Query1[Available_Bal]

Also, I want to keep the column name as "Balance" instead of "Query1[Balance]"

Please suggest the way out.

Answer 1

Yes, this is power povit, the "manage" icon is goto manage data model. Then you will see the name (Query1) in it like a sheet name which show before your column name when double click the sum of values.

Answer 2

Dear sir,

What i want is to remove query1[ ] from the column name and keep text only. Also i wam working on power pivot not power query and want to reorder the column.

Answer 3

There is no way to remove the query name (the name cannot be blan) from show details. And the order is by design, you may change it manual or use formula to change the column location.

You may change the quey name from

PowerQuery>Manage>change the query name you want.

Answer 4

Dear Sir,

Please find the dropbox link here

https://www.dropbox.com/scl/fi/fhohj4m740chvcsv7nu63/Sample.xlsx?rlkey=n1fpd2vafkzwnhsau8855810o&dl=0

Answer 5

Could you share us a test file or some screenshot of your issue? Then we may reproduce your issue and give suggestions on it.

For sharing a sample workbook, upload to OneDrive or any other cloud drives. Then post a link here.