Answered by:
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
Wednesday, June 27, 2018 6:20 PM
Answers
-
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 MSDNFSF@microsoft.com- Proposed as answer by alexander fun Friday, June 29, 2018 1:12 PM
- Marked as answer by Combine 2 Power query formulas Thursday, July 5, 2018 11:43 AM
Thursday, June 28, 2018 3:30 AM -
Not necessary I see. However it's based on alphabet.
- Marked as answer by Combine 2 Power query formulas Thursday, July 5, 2018 11:43 AM
Monday, July 2, 2018 2:28 PM -
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 MSDNFSF@microsoft.com- Edited by willson yuanMicrosoft contingent staff Thursday, July 5, 2018 7:38 AM edit
- Marked as answer by Combine 2 Power query formulas Thursday, July 5, 2018 11:43 AM
Thursday, July 5, 2018 7:37 AM
All replies
-
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 MSDNFSF@microsoft.com- Proposed as answer by alexander fun Friday, June 29, 2018 1:12 PM
- Marked as answer by Combine 2 Power query formulas Thursday, July 5, 2018 11:43 AM
Thursday, June 28, 2018 3:30 AM -
Hi Willson,
But it is sorted in a different way than my raw data. On which criteria is the sorting based?
Kind regards,
Mark
Thursday, June 28, 2018 9:37 PM -
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 MSDNFSF@microsoft.comMonday, July 2, 2018 5:09 AM -
Not necessary I see. However it's based on alphabet.
- Marked as answer by Combine 2 Power query formulas Thursday, July 5, 2018 11:43 AM
Monday, July 2, 2018 2:28 PM -
I have another question.
For each column after down drilling I see the Source Name [field name].
How do I hide the source name?
Wednesday, July 4, 2018 4:48 PM -
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 MSDNFSF@microsoft.com- Edited by willson yuanMicrosoft contingent staff Thursday, July 5, 2018 7:38 AM edit
- Marked as answer by Combine 2 Power query formulas Thursday, July 5, 2018 11:43 AM
Thursday, July 5, 2018 7:37 AM -
There a lot of things that PowerPivot can not do. It needs some work from Microsoft I think!Thursday, July 5, 2018 11:43 AM