Extract numbers/text from string option in PowerQuery UI
I wish there was an option in the PowerQuery UI to extract either numbers or text from a string. This is a fairly common requirement among clicky clicky draggy droppy types, and while yes this can be accomplished with PowerQuery functions, it would be great if it can also be accomplished by the 9...
[PowerQuery] Filter column dynamically by MAX value in that column from the UI
Wouldn't it be cool if a mere mortal could filter a column by the maximum value in that column dynamically right from the Number Filters menu via the trangular drop down button at the top of each column in PQ. This is a fairly common requirement among clicky clicky draggy droppy types, and whil...
Give us a Name Box in the ribbon to name objects on the canvas easier (like Excel has)
I think a VERY good habit to get in to when creating #PowerBI reports is to name every object on the canvas using the Selection Pane. And where you can, use a naming convention. (Sometimes you can't...e.g. names here are also used by Chart Titles). You know what would make this soo much easier ...
Allow users to set Shape Width/Height below 40 in Width/Height Well
Power BI will let you manually size shapes down to 14 x 14. But if you try to use the Width/Height well to change size, it won't let you go below 40 if you're above, and won't let you go up from < 40 if you're below. There are very good reasons why we might want to go down to 14 or even lower, a...
Make the Apply Filter button in the Filters pane light up when Filter amended
The "Apply filter" button should light up if you've changed something in the Filter Pane but haven't applied it yet. It's so easy to think you've set a filter, and then close the pane...even when you've used the App a lot. Alternately, apply the filters as we set them, but give us a Defer Upda...
Selection Pane Show/Hide buttons need to be more easily visually distinguishable
With large numbers of objects in a dashboard, it can be difficult to easily scan and identify which are hidden and which are not in the Show/Hide pane, because the only difference between the icons is a diagonal line. I would like to see either the same icons as PowerPoint used (with a dash for ...
Better visual cue for when "Enable Load" deselected
could do with a bigger visual cue is "Enable Load". If you deselect "Enable Load" in PowerQuery, the query names get italicized. But with lots of queries, it is more effort to visually parse this quite subtle cue (italics vs non italics) when looking at a large number of queries. Especially for...
Change mouse-over to wave-over on public dashboards until Covid-19 has peaked
Adjust Xpos, Y-pos, Height and Width right from the ribbon formatting pane
It would be real handy if we could adjust X pos, Y pos, height, and width right from the ribbon as per this Twitter thread: https://twitter.com/InsightsMachine/status/1235700978613014529 (This would be better than what PowerPoint and Excel give - they don't allow you to adjust X pos and Y pos r...
Warn me when my M/PowerQuery code references fields that don't exist.
Is there any reason why #PowerQuery couldn't warn you if you've misspelled [Some_Colum] like it does if you mistype #"Some Stepp"? When refactoring in #PowerBI and #Excel I sometimes replace source queries, then spend ages hunting down field names that don't match.