How can we improve Power BI?

Expressions on filters

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

92 votes
Sign in
(thinking…)
Sign in with: Facebook Google
Signed in as (Sign out)

We’ll send you updates on this idea

Vicenç Lahoz shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

9 comments

Sign in
(thinking…)
Sign in with: Facebook Google
Signed in as (Sign out)
Submitting...
  • Simon commented  ·   ·  Flag as inappropriate

    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.

  • Wildmight commented  ·   ·  Flag as inappropriate

    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  ·   ·  Flag as inappropriate

    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

  • Leonard Murphy commented  ·   ·  Flag as inappropriate

    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.

  • KT commented  ·   ·  Flag as inappropriate

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

  • Martin Höglund commented  ·   ·  Flag as inappropriate

    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  ·   ·  Flag as inappropriate

    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 :-)

Feedback and Knowledge Base

Ready to get started?

Try new features of Power BI today by signing up and learn more about our powerful suite of apps.