Change drill down order (Power Pivot and Power Query)

Question

Dear all,

I've a Power Pivot with data source Power Query.

When I drill down to my data the columns aren't in the order that I want. Can I change that? I searched online, but didn't really find the right solution for my problem.

Kind regards,

Mark

Answer 1

Hi Mark,

Thanks for your question.

>>>When I drill down to my data the columns aren't in the order that I want. Can I change that? I searched online, but didn't really find the right solution for my problem.
Unfortunately, the drill down action will return the raw data from the related underlying tables, we can't apply sorting options manually, thus we can not change the dataset order returned from drill down currently.

---

Best Regards
Willson Yuan
MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact [e-mail]

Answer 2

Hi Willson,

But it is sorted in a different way than my raw data. On which criteria is the sorting based?

Kind regards,

Mark

Answer 3

Hi Mark,

Thanks for your response.

>>>But it is sorted in a different way than my raw data. On which criteria is the sorting based?

Based on my search, it will based on the sorting of your Power Query data set.

---

Best Regards
Willson Yuan
MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact [e-mail]

Answer 4

Not necessary I see. However it's based on alphabet.

Answer 5

I have another question. 

For each column after down drilling I see the Source Name [field name].

How do I hide the source name?

Answer 6

Hi Mark,

Thanks for your response.

>>>How do I hide the source name?
If you mean source table name, we can not hide the source table name unfortunately.

One more thing, please kindly mark the helpful replies as answers. By doing so, it will benefit all community members who are facing this similar issues. Your contribution is highly appreciated.

---

Best Regards
Willson Yuan
MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact [e-mail]

Answer 7

There a lot of things that PowerPivot can not do. It needs some work from Microsoft I think!