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.

[lokojo]

Can you please also add the forced selection like currently available in chiclet slicer, its very much needed? Thanks in advance for help.

[walejustin]

How many votes are required for an idea to approved ?

[craig_bryden1]

We need this to be programmable. Maybe have a DAX measure that returns the default value that should be selected. As an example, select the user's department by default, while still leaving the other selections available.

[Arjun_Ariyil]

I have a month slicer (Jan, Feb, Mar, ...) and a year slicer (2020, 2021, ...) I want the current month and year to be selected by default after the report refresh. But the user should be able to select previous months and years also. I cannot use a relative date slicer as it is confusing to the user. This feature is definitely a must in any BI Platform with automated data refresh.

[bsvannierop]

I teach all my users (not techsavy at all) to return to default settings after opening the report, because they forget what they have filtered (and get confused). How nice would it be if at least my year and month would return to the current month setting (instead of the hardcoded current year and January because I don't want to republish every month).

[mshparber5]

Please make it happen! The relative date slicer is confusing and doesn't address many cases. We need a DEFAULT value for FILTERS and SLICERS based on a free DAX formula. Thank you!

[fbcideas_migusr]

Setting default values for slicers is a nightmare in Power BI. This is probably the biggest miss in the tool.

[fbcideas_migusr]

We have cases where reports need to be filtered by default to a certain value for a field with ability for a user to switch to another if required. That default value can change each month or randomly. The value we want to filter is flagged in a config table. Without an ability to set default filter logic say via a measure or some other means, we don't have any way to address this. Please add this feature.

[srfrzlm898]

It is a must have feature in my reports user wanted to see data for 6 months default when no date range slicer is selected but when range is selected it should show data that comes under given range Please add this feature.

[fbcideas_migusr]

We use the SSAS multidimensional "default member" concept heavily in our legacy enterprise BI system. Not having a dynamic method for setting a default filter/slicer is a major pain point in moving to Power BI as not all of our users have the same level of expertise in navigating BI reports. Would love to see something in a shared dataset that could be consumed by other Power BI users and Excel users.