Skip to main content

Power BI

Needs Votes

Epic idea: Apply filter selections automatically

Vote (4553) 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 06 Jul 2020 00:17:07

RE: Epic idea: Apply filter selections automatically

Please make it happen! The relative date slicer is confusing and doesn't address many cases. We need a DEFAULT value for FILTERS and SLICERS based on a free DAX formula.
Thank you!

Miguel Myers's profile image Profile Picture

Arjun on 06 Jul 2020 00:17:00

RE: Epic idea: Apply filter selections automatically

I have a month slicer (Jan, Feb, Mar, ...) and a year slicer (2020, 2021, ...)
I want the current month and year to be selected by default after the report refresh. But the user should be able to select previous months and years also.

I cannot use a relative date slicer as it is confusing to the user.
This feature is definitely a must in any BI Platform with automated data refresh.

Miguel Myers's profile image Profile Picture

Craig Bryden on 06 Jul 2020 00:16:51

RE: Epic idea: Apply filter selections automatically

We need this to be programmable. Maybe have a DAX measure that returns the default value that should be selected. As an example, select the user's department by default, while still leaving the other selections available.

Miguel Myers's profile image Profile Picture

jake on 06 Jul 2020 00:16:44

RE: Epic idea: Apply filter selections automatically

Can you please also add the forced selection like currently available in chiclet slicer, its very much needed? Thanks in advance for help.

Miguel Myers's profile image Profile Picture

Mariia on 06 Jul 2020 00:16:36

RE: Epic idea: Apply filter selections automatically

Voting for this idea because I need to show data from first day of current month till the last date in the date field by default and also provide users with ability to move left circle to see historical dates. I'm using slicer with "between" option and I can't set first day of the month (or today () , for example) as a date for left circle by default.

Miguel Myers's profile image Profile Picture

Elaw Justin on 06 Jul 2020 00:16:25

RE: Epic idea: Apply filter selections automatically

How many votes are required for an idea to approved ?

Miguel Myers's profile image Profile Picture

Gary Smith on 06 Jul 2020 00:15:54

RE: Epic idea: Apply filter selections automatically

Upvote. This should be standard functionality

Miguel Myers's profile image Profile Picture

Laurens SNoek on 06 Jul 2020 00:15:34

RE: Epic idea: Apply filter selections automatically

Any update?

Miguel Myers's profile image Profile Picture

Power BI Ideas Admin on 06 Jul 2020 00:15:18

RE: Epic idea: Apply filter selections automatically

Anyone from Microsoft can comment on the status?

Miguel Myers's profile image Profile Picture

Matt Hamann on 06 Jul 2020 00:15:09

RE: Epic idea: Apply filter selections automatically

Can Power Bi give an update on the status of this? I need a report to default to current year and current pay period, out of a query that is generated every week. Right now the report consumers need to select the year and current period. The VP's want it to default to current on both hence the request. So right now for instance we would want year 2020, and period 22 selected in the slicer.

Merged Idea (1)