Skip to main content

Power BI

Needs Votes

Epic idea: Apply filter selections automatically

Vote (4624) Share
Miguel Myers's profile image

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)
Miguel Myers's profile image Profile Picture

Naman Verma on 05 Jul 2020 22:53:12

RE: Epic idea: Apply filter selections automatically

definitely, need this feature. Any timeline when this is expected to roll out.

Miguel Myers's profile image Profile Picture

belvoir on 05 Jul 2020 22:52:59

RE: Epic idea: Apply filter selections automatically

To be able to store default values in a table for a user and then use RLS to load their individual preferences would be awesome!

Miguel Myers's profile image Profile Picture

belvoir on 05 Jul 2020 22:52:25

RE: Epic idea: Apply filter selections automatically

There are broadly two issues in this improvement: setting default slicer values upon opening, and setting dynamic values such as current month.

For the former, it would be great we could set default slicer values as a set of parameters in a separate list in the designer. For true awesomeness, we could apply RLS to the parameters so each user could have their own default settings.

Miguel Myers's profile image Profile Picture

Power BI User on 05 Jul 2020 22:52:18

RE: Epic idea: Apply filter selections automatically

Please, need this feature.. : )

Miguel Myers's profile image Profile Picture

Power BI User on 05 Jul 2020 22:52:15

RE: Epic idea: Apply filter selections automatically

I would like to be able to default my date slicers to something like "last 5 quarters" or "last 13 months" so that anybody opening the report would that data by default. However, the users should be able to change the data range to anything.

Adding a calculated column and then using that calculated column as a filter is okay, except then the user is unable to have the flexibility needed.

Miguel Myers's profile image Profile Picture

Patrick P on 05 Jul 2020 22:52:14

RE: Epic idea: Apply filter selections automatically

Missing this basic feature is hampering adoption of the PBI dashboards. If the data in a dashboard is difficult to force to be current by applying a default, and you have to click the dashboard to get to the report to filter for current data, then the dashboard is nearly useless.

Miguel Myers's profile image Profile Picture

Trevor Howe on 05 Jul 2020 22:52:10

RE: Epic idea: Apply filter selections automatically

Please, please, please

The suggestions around of having a calculated measure for "current month" are "cute" but not like the robust way for example in Reporting Services where each parameter can have a default value.

Miguel Myers's profile image Profile Picture

Param Saraf on 05 Jul 2020 22:52:02

RE: Epic idea: Apply filter selections automatically

That would be a great help (y)

Miguel Myers's profile image Profile Picture

Power BI User on 05 Jul 2020 22:51:02

RE: Epic idea: Apply filter selections automatically

This would be a great help in most of the reports we are using.

Miguel Myers's profile image Profile Picture

Jeff Joll on 05 Jul 2020 22:50:11

RE: Epic idea: Apply filter selections automatically

I am new to Power BI but quickly seeing the need / desirability of setting a default value for a slicer - particularly dates.

Merged Idea (1)