Skip to main content

    Power BI

    Needs Votes

    Epic idea: Apply filter selections automatically

    Vote (4617) 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 (417)
    Miguel Myers's profile image Profile Picture

    on 31 Jul 2023 21:06:40

    RE: Epic idea: Apply filter selections automatically

    Suppose I have a year slicer in a power bi report and I want to show default value is current year that time it is helpfulBy default selection in current year shows all business of the current year

    Miguel Myers's profile image Profile Picture

    Suvarna Yenugudhati on 27 Jul 2023 04:22:51

    RE: Epic idea: Apply filter selections automatically

    Any progress? We encounter numerous reporting scenarios that necessitate default date ranges in our slicers. Currently, the slicers are manually set to the start and end of the month, requiring a monthly update.

    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...

    Merged Idea (1)