Expressions on filters

[vlahoz2]

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

[nishalit]

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

[robert_french]

Not sure if this is the best place to put this comment, here goes any way 🙂 Would it be possible to use DAX expressions in filters? I was trying something this morning which would automate a report based on time values. Example l want to only show incidents for the current year on a page on a report eg Year = 2015. What l would like to have done is something like =YEAR(TODAY () ). Which if l could use DAX in a filter expression that is pretty awesome 🙂

[martin_hoglund]

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!

[ktodorov]

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

[fbcideas_migusr]

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.

[fbcideas_migusr]

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.

[richard_lautman]

any update on this?

[francescopuntoc]

Any Updates?

[fbcideas_migusr]

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

[wildmight]

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!