Skip to main content

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...

Read more...
0 Comments

Read more...
0 Comments

STATUS DETAILS
Needs Votes

[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...

Read more...
0 Comments

Read more...
0 Comments

STATUS DETAILS
Needs Votes

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 ...

Read more...
0 Comments

Read more...
0 Comments

STATUS DETAILS
Needs Votes

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...

Read more...
0 Comments

Read more...
0 Comments

STATUS DETAILS
Needs Votes

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...

Read more...
0 Comments

Read more...
0 Comments

STATUS DETAILS
Needs Votes

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 ...

Read more...
0 Comments

Read more...
0 Comments

STATUS DETAILS
Needs Votes

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...

Read more...
0 Comments

Read more...
0 Comments

STATUS DETAILS
Needs Votes

Change mouse-over to wave-over on public dashboards until Covid-19 has peaked


I'm predicting an epidemic of votes for this one.

Read more...
0 Comments

Read more...
0 Comments

STATUS DETAILS
Declined

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...

Read more...
0 Comments

Read more...
0 Comments

STATUS DETAILS
Needs Votes

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.

Read more...
0 Comments

Read more...
0 Comments

STATUS DETAILS
Needs Votes