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)
- Merged Idea (1)
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.
RE: Epic idea: Apply filter selections automatically
HI ANY UPDATES ON THIS
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!
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.
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!
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.
RE: Epic idea: Apply filter selections automatically
Just a categorical preset filter based on RLS please!
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.
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.
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.