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)
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.
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.
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!
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
RE: Expressions on filters
Any Updates?
RE: Expressions on filters
any update on this?
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.
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.
RE: Expressions on filters
Power BI is currently pretty static. Allowing some dynamic behavior through expressions is a must have for sure!
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!