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)
- Merged Idea (1)
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.
RE: Epic idea: Apply filter selections automatically
Just want to reiterate:
"Sticky Filters" and "Relative date" filter do not address this issue. I am looking for
an option to set the date slicer default value to a calculated measure in the visualization option so that when the report refreshes in PBI Service, the selected date slicer value is updated to the latest value from the measure.
RE: Epic idea: Apply filter selections automatically
Any word on creating a default value for filters that uses DAX? Basically set the filtered value to TODAY () but don't filter the entire page by that. A date selector for example that defaults to today BUT the user can go back as far as they desire.
RE: Epic idea: Apply filter selections automatically
I vote for this, and this is very much needed!