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
I need the ability to set a default relative date (e.g. the last 30days) but have the slicer sent to between. The relative date slicer does not work for many reports.
RE: Epic idea: Apply filter selections automatically
I need to be able to default a date slicer to a "Current (time period)". And then give the user the ability to select another non-default item from the slicer, but it should default to the specified value when opened/reset.
This is highly needed!
Thanks!
RE: Epic idea: Apply filter selections automatically
Yes, this idea is critical. For example there are some reports where we would love to default the department to that user's department automatically. Having the ability to dynamically change the default would solve this. Similar to how it works in SSRS, you can return the value you want to use in another data set. I foresee where in Power BI you could do something similar. We have attempted to use Row level security and work around it by basically populating a table with every single possible slicer value for every user and then just setting the default to "My Dept." or something like that...but it's not very salable as more users start.
RE: Epic idea: Apply filter selections automatically
I would need to be able to default the slicer to a certain period, for example the prior period. I still need to have an option to select other periods as needed. The reason is that the previous period is needed 95% of the time, but the remaining 5% of the time they the user would look at other periods.
RE: Epic idea: Apply filter selections automatically
This is a very important request
RE: Epic idea: Apply filter selections automatically
I would need a default for last month or quarter but without using the relative date filter.
The reason is that the users need to be able to select a specific quarter years back while still allowing the report to always display the current quarter. While a relative date slicer solves the later it means that we need to add another date slicers that the users need to uncheck revert time they want to go back to say Q2 2017.
RE: Epic idea: Apply filter selections automatically
This is critical.
The only workaround for now is to change the slicer value each day/week/month/year, save and republish. In a controlled production environment requiring a Change Request to promote production changes - too much operational overhead. Must address.
RE: Epic idea: Apply filter selections automatically
This is a critical update in my opinion.
RE: Epic idea: Apply filter selections automatically
Many customers are asking about Synchronizable Calendar Slicers where you can default to yesterday's day for example. And have a Calendar Widget to choose 'ONE' day only, instead of a pair of dates.
RE: Epic idea: Apply filter selections automatically
Another request is to be able to pass a date parameter to the Sync Calendar control and determine current value for the date(s)