Skip to main content

Power BI

Under Review

Expressions on filters

Vote (101) Share
Vicenç Lahoz's profile image

Vicenç Lahoz on 08 Jan 2015 17:07:05

Allow dynamic filters, for example last month, last year, etc. Or allow expressions similar to those of Reporting Services.

Administrator on 24 Jan 2015 06:27:04

Thanks for the idea, Vicenc! We'll consider it for the future, please add your votes it you agree!

Comments (11)
Vicenç Lahoz's profile image Profile Picture

Power BI User on 05 Jul 2020 23:58:55

RE: Expressions on filters

This is a must function. We have to set up our reports on current year and month less or equal than current month.

Vicenç Lahoz's profile image Profile Picture

Power BI Ideas Admin on 05 Jul 2020 23:34:36

RE: Expressions on filters

Please could this be extended to cover all the options in the Format pane, especially the Action options. It would be great to be able to dynamically set a bookmark based on the results of a Dax expression.

Vicenç Lahoz's profile image Profile Picture

Wildmight on 05 Jul 2020 23:22:04

RE: Expressions on filters

This would be extremely useful to use columns in filter field. (For instance - Current Year or Top Customer). Or even for MTD, QTD metrics where you need to filter on date to see results. Thank you!

Vicenç Lahoz's profile image Profile Picture

Evandro Muchinski on 05 Jul 2020 23:19:09

RE: Expressions on filters

On the Advanced Filters option, add an 'Expression' option. It would allow, for example, to filter by a function like =username () or any other valid DAX expression.

In addition, the expression used to filter could came from an existing measure, so it would ease the case of many visuals using the same Expression filter.

This image gives an overview of the idea:
https://1drv.ms/u/s!AlZdtnb1ar0zg8Fx-wsKJ26OEP0hxQ

Vicenç Lahoz's profile image Profile Picture

Francesco Cordella on 05 Jul 2020 22:49:51

RE: Expressions on filters

Any Updates?

Vicenç Lahoz's profile image Profile Picture

Power BI User on 05 Jul 2020 22:35:00

RE: Expressions on filters

any update on this?

Vicenç Lahoz's profile image Profile Picture

Greg Galloway on 05 Jul 2020 22:31:53

RE: Expressions on filters

I really need to be able to default a Department field's filter to "my department". If I could apply a DAX expression as the filter expression, then I could use the USERNAME () function in DAX and lookup that user's department and default to their department. This would be very powerful.

Vicenç Lahoz's profile image Profile Picture

Leonard Murphy on 05 Jul 2020 22:26:48

RE: Expressions on filters

You can create a calculated column with a DAX expression that will allow for dynamic filtering. E.g. in your date table, create a calculated column that shows "Current Month" for the current month, and the month name (Jul 2016, Jun 2016, etc.) if it isn't current. Then you can slice on "Current Month" and never have to update that slicer. Of course, that's not as intuitive as being able to do such an expression right in the filter.

Vicenç Lahoz's profile image Profile Picture

KT on 05 Jul 2020 22:19:01

RE: Expressions on filters

Power BI is currently pretty static. Allowing some dynamic behavior through expressions is a must have for sure!

Vicenç Lahoz's profile image Profile Picture

Martin Höglund on 05 Jul 2020 22:14:56

RE: Expressions on filters

I need this feature to keep the dashboard shown in mobile app up to date, just showing "current week" etc.
And it has to work throw Enterprise Gateway to SSAS MD!