Skip to main content

    Power BI

    Needs Votes

    Epic idea: Apply filter selections automatically

    Vote (4578) Share
    Miguel Myers's profile image

    Miguel Myers on 08 Oct 2024 05:00:00

    Imagine a world where report creators can automatically apply slicer and filter selections based on specific logic, revolutionizing data analysis and user experience. This innovative approach eliminates any need for complex workarounds, optimizes slicer functionality, and paves the way for more efficient and effective data reporting.

    Comments (415)
    Miguel Myers's profile image Profile Picture

    Michael Shparber on 25 Jul 2023 07:46:21

    RE: Epic idea: Apply filter selections automatically

    Any Updates?

    Miguel Myers's profile image Profile Picture

    David Curtin on 22 May 2023 10:21:05

    RE: Epic idea: Apply filter selections automatically

    Any updates on this approaching end of Q2 now 8 years later!

    Miguel Myers's profile image Profile Picture

    Nikolay Matveichev on 18 May 2023 13:21:08

    RE: Epic idea: Apply filter selections automatically

    We also need this functionality.Dear Microsoft pleas stop firing your programmers, there are plenty of things to be done here!

    Miguel Myers's profile image Profile Picture

    Carina Louzao on 13 Apr 2023 23:05:27

    RE: Epic idea: Apply filter selections automatically

    Any update on when this will be available? My client wants their reports to use the timeline slicer for 5 years' worth of data and have it default to the last 6 months. A relative date slicer will not work, as they need precise control over the filtered dates. Using two slicers in tandem will not work as it is not user friendly.

    Miguel Myers's profile image Profile Picture

    Laurence S on 14 Jul 2022 15:49:40

    RE: Epic idea: Apply filter selections automatically

    One way this could be implemented is by adding a "Default" option in the slicer detail pane. Then allow either a relative date or dax formula to specify the starting date range desired.

    Miguel Myers's profile image Profile Picture

    James Barwegen on 22 Jun 2022 18:21:24

    RE: Epic idea: Apply filter selections automatically

    As many users have commented, being able to set the default value for filters dynamically would be great. For example, date formats could let you set "greater than 12 months ago" and "less than 11 months ago". Or number formats could filter by "greater than" and "less than". Text formats could do the normal "starts with" or "contains". Etc.. This helps to define filters to be updated automatically as time passes and more data enters into the dataset that can't be identified/named during the development of the model.

    Miguel Myers's profile image Profile Picture

    Cameron Hicks on 13 Feb 2022 23:00:54

    RE: Epic idea: Apply filter selections automatically

    In date slicer we should be able to set a default date dynamically, e.g today, yesterday

    Miguel Myers's profile image Profile Picture

    Mitch Alves on 14 Jan 2022 18:06:06

    RE: Epic idea: Apply filter selections automatically

    This should have been out of the box... This feature was amazing in SSRS, why didn't they bring it to PBI is mind boggling...

    Miguel Myers's profile image Profile Picture

    Steven Taub on 29 Apr 2021 15:05:29

    RE: Epic idea: Apply filter selections automatically

    This seems like such a simple ask...

    Miguel Myers's profile image Profile Picture

    Stefan Van Zyl on 23 Oct 2020 09:23:23

    RE: Epic idea: Apply filter selections automatically

    There is a similar idea with more votes here

    Lets keep the votes in one place to speedup the urgency for this feature.

    Thanks!

    Plain URL: https://ideas.powerbi.com/ideas/idea/?ideaid=d299ee70-6fb5-4231-a30b-540a4b653671

    Merged Idea (1)