Expressions on filters
Allow dynamic filters, for example last month, last year, etc. Or allow expressions similar to those of Reporting Services.
Thanks for the idea, Vicenc! We’ll consider it for the future, please add your votes it you agree!
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.
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!
Evandro Muchinski commented
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:
Francesco Cordella commented
any update on this?
Leonard Murphy commented
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.
Power BI is currently pretty static. Allowing some dynamic behavior through expressions is a must have for sure!
Martin Höglund commented
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!
Robert French commented
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 :-)