Skip to main content

Power BI

Needs Votes

[PowerQuery] Filter column dynamically by MAX value in that column from the UI

Vote (2) Share
Jeffrey Weir's profile image

Jeffrey Weir on 24 Jan 2020 13:32:54

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 while yes this can be accomplished with PowerQuery functions, it would be great if it can also be accomplished by the 99.998% of users that don't want to get M on their hands.