Hey everyone, we need your votes to make a difference in Power Query and Power Pivot! There are a couple of items in the uservoice forums that I’d like to bring your attention to, and hopefully entice you to vote them up. The more votes we get, the easier it is for the program managers in the design teams to get the support to actually implement these features. They ARE interested, they just need you to up-vote them to get them done.
Where we need your votes:
#1 - Add Intellisense to the M Editor
So the idea here is simple: Add Intellisense and better general editing capabilities in the Advanced Editor. This would make a huge difference to those of us writing M code, and I’ve also suggested in the comments that this be extended to the Add Custom Column dialog.
What kills me on this is the signature of the original submitter: “Software Engineer, Power BI Desktop”. I don’t think I’ve ever seen a clearer case where they need our help to justify the budget to get this done. Please go there and throw some votes on this.
Vote up the “Add Intellisense to the M Editor” idea.
#2 – Modification of the Power Pivot Field List experience
Back in November I posted a suggestion to improve the Pivot Table experience which would benefit everyone, but especially Power Pivot users. Full details of my suggestion can be found on the blog here, but the basic summary is this: Allow the fields area to be collapsible in side by side view. This would make it WAY easier to rearrange fields by reducing unused whitespace.
I was really encourage to see Ashvini Sharma’s response which, paraphrased, says: “We want to do this too, so please get enough votes to help us justify it!”
Vote up the “Ability to collapse PivotTable field areas” idea.
My Ask To You
Please, take some time to throw some votes on these ideas, and encourage every other user you know to do the same. It’s super easy to do, just go there, click the Vote button, assign as many as you want and verify you’re real with your email address. (The only email I’ve ever received from this is when they confirmed a feature got implemented.)
Again, we need your votes. Help us out! I’d like to see both of these hit 500 votes in order to give Microsoft the justification they need to get these done.