Skip to main content

Power BI

Needs Votes

Epic idea: Apply filter selections automatically

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

Jinu Alappatt on 05 Jul 2020 23:56:50

RE: Epic idea: Apply filter selections automatically

It will be great if we can have a search button on slicers and selects all of them which is filtered using search button as in Excel Filter. Currently the search button is on top of the filter and nothing has been selected based on it. We need to select them one by one after it is filtered.

Miguel Myers's profile image Profile Picture

is on 05 Jul 2020 23:56:35

RE: Epic idea: Apply filter selections automatically

HI ANY UPDATES ON THIS

Miguel Myers's profile image Profile Picture

vinay david on 05 Jul 2020 23:56:18

RE: Epic idea: Apply filter selections automatically

Any Updates on this request? Quite a long that this idea is still under Review. Would be great if this feature can be incorporated. Thanks!

Miguel Myers's profile image Profile Picture

James.A.Watts on 05 Jul 2020 23:56:04

RE: Epic idea: Apply filter selections automatically

A more general solution might be to set a slicer to default to the max or min value, so it would work with more than dates.

Miguel Myers's profile image Profile Picture

Rafael Moreno on 05 Jul 2020 23:54:39

RE: Epic idea: Apply filter selections automatically

We need to be able to set up the date of a date slicers to "today", so whenever the user opens-up the report the current day will be filtered.

Bear in mind that is a situation where it's needed to be able to set-up a standard value for the filter (sticky filter won't help at all on that) and also the value that will be fixed as the standard filter option has to be either a measure or a fixed value. We need options!

Miguel Myers's profile image Profile Picture

Power BI User on 05 Jul 2020 23:54:37

RE: Epic idea: Apply filter selections automatically

Is this one still under review? It's such a simple one but it would be so great to have.

Miguel Myers's profile image Profile Picture

MArce on 05 Jul 2020 23:54:07

RE: Epic idea: Apply filter selections automatically

Just a categorical preset filter based on RLS please!

Miguel Myers's profile image Profile Picture

Andrew Whiteway on 05 Jul 2020 23:52:54

RE: Epic idea: Apply filter selections automatically

Hi Will,

For our reports, we tend to want to set the default "Month" slicer to current month. At the moment we can do that by renaming the most current month to "current month" and having that selected by default, but doing something similar while keeping the month name would be great. For example, would be great to set the slicer to the value of a "max month" measure. That's just one example, but a common one for our teams.

Miguel Myers's profile image Profile Picture

Ann Krause on 05 Jul 2020 23:51:54

RE: Epic idea: Apply filter selections automatically

I have a detail report connected to a multi-dimensional SSAS cube that takes way too long to load. What I'd like to do is pre-select the most frequently ordered product in the Product slicer (for the orders report) or the product with the highest inventory (for the inventory report), but I can't see a way to do this without using DAX. Since DAX isn't available to me when connecting live to our cube, I can't use DAX or create measures within Power BI.

Miguel Myers's profile image Profile Picture

YO on 05 Jul 2020 23:51:47

RE: Epic idea: Apply filter selections automatically

Would be great if we as developers could assign default selection for dates filter, based on DAX measure. For example, each passing day the default selection would change to the current day, or a different day based on DAX measure like "last update date" from a fact table.
At the moment this is very frustrating to customers.

Merged Idea (1)