Epic idea: Apply filter selections automatically

[Miguel_Myers]

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.

[lspector]

One way this could be implemented is by adding a "Default" option in the slicer detail pane. Then allow either a relative date or dax formula to specify the starting date range desired.

[carina_louzao]

Any update on when this will be available? My client wants their reports to use the timeline slicer for 5 years' worth of data and have it default to the last 6 months. A relative date slicer will not work, as they need precise control over the filtered dates. Using two slicers in tandem will not work as it is not user friendly.

[NMatveichev]

We also need this functionality.

Dear Microsoft pleas stop firing your programmers, there are plenty of things to be done here!

[david30]

Any updates on this approaching end of Q2 now 8 years later!

[mshparber1]

Any Updates?

[fbcideas_migusr]

Any progress? We encounter numerous reporting scenarios that necessitate default date ranges in our slicers. Currently, the slicers are manually set to the start and end of the month, requiring a monthly update.

[nishalit]

Suppose I have a year slicer in a power bi report and I want to show default value is current year that time it is helpful

By default selection in current year shows all business of the current year

[Tom_Powers]

Will this idea address being able to change or switch Slicer Selection based on another Slicer Selection?

https://community.fabric.microsoft.com/t5/Desktop/Change-or-switch-slicer-selection-based-on-another-slicer/m-p/3371565#M1122541

Sometimes a user creates a parameter table with a slicer that lets them slice between multiple measures to change a visual. If a user creates a second slicer from another column to filter those measures -- in the example above -- between different unit conversions, the previous selection stays the same, and the visual goes blank if the user selects the second slicer. It would be great if the user could select the second slicer, and the visual and previous selection update accordingly.

[WAdams]

Slicers are so inconsistent, they are easily my least favorite part of Power BI.

For instance, if a slicer exists on page with a value 1 selected AND on the same dimension one would add a filter with a value 2 (either through the Filter functionality or pushed through the URL when embedding the page in HTML), the slicer will still show the value 1 selected but will also show the value 2 (set through the filter) but visually unselected.

In reality, both values are selected at this time because doing a SELECTEDVALUE() on the dimension returns nothing meaning both are selected.

What kind of mixed message does this give to the user seeing this as well as end up with wrong data (due to both values being selected).

Slicers urgently need to be overhauled to provide some consistency. This includes the ability to set a default value but also when done, it should UNSELECT the previously set value (which today it does not).

Thanks

[fbcideas_migusr]

Any updates to share? Administrator message dated May 20, 2024 stated rummy