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

Hussain Contractor on 05 Jul 2020 22:46:20

RE: Epic idea: Apply filter selections automatically

Much needed

Miguel Myers's profile image Profile Picture

YUKOS on 05 Jul 2020 22:45:41

RE: Epic idea: Apply filter selections automatically

Hello Team,
It would be a great thing to be able to default values using a slicer. If I have a set of years, I would like to be able to have "2017" as default value automatically, meaning that every time you have a new calendar year, Power BI Slicer will default to the new year.

Cheers,

YUKOS

Miguel Myers's profile image Profile Picture

Power BI User on 05 Jul 2020 22:45:32

RE: Epic idea: Apply filter selections automatically

A must

Miguel Myers's profile image Profile Picture

Alberto on 05 Jul 2020 22:45:27

RE: Epic idea: Apply filter selections automatically

It is a MUST.

Miguel Myers's profile image Profile Picture

Thomas Martens on 05 Jul 2020 22:45:12

RE: Epic idea: Apply filter selections automatically

Set a value for the selection of a slicer is a must have, please consider to evaluate a measure returning a table that contains a single column with one or many rows

Miguel Myers's profile image Profile Picture

steve wickens on 05 Jul 2020 22:45:06

RE: Epic idea: Apply filter selections automatically

I would like to see the ability to set the start and end ranges of a date slicer to select from a formula or query so that (for example) the user, when accessing the report, will see the last complete month selected for them. TODAY () = 3/3/2017 Slicer range should default to 1st Feb 2017 to 28th Feb 2017.

Miguel Myers's profile image Profile Picture

Scott Ferguson on 05 Jul 2020 22:44:38

RE: Epic idea: Apply filter selections automatically

Along the same line of thought, the functionality for certain options to always be selected and the filter to select additional items would be helpful. For instance, I want my companies' locations to always appear on a map, and a filter to select certain competitors. Eliminating the step to not have to select my company locations each time would be nice. It may be best for the default items not to appear in the filter.

Miguel Myers's profile image Profile Picture

Power BI User on 05 Jul 2020 22:44:34

RE: Epic idea: Apply filter selections automatically

This would also be useful to prevent SAMEPERIODLASTYEAR measures failing because a Month slicer was used before the Year slicer thus showing an error message due to non-contiguous date ranges. Ensuring that a single (and only one) value must always be selected on certain visualisations would be great.

Miguel Myers's profile image Profile Picture

Andrés RM on 05 Jul 2020 22:44:09

RE: Epic idea: Apply filter selections automatically

Must have to open most of reports in a meaningfull way

Miguel Myers's profile image Profile Picture

Alejandro on 05 Jul 2020 22:44:09

RE: Epic idea: Apply filter selections automatically

This feature it's basic, when you are Analyzing metrics in daily basis, in mothly basis etc...

It's also very important when you work with large sets of data in direct query due to trying to minimize work load to the database

Merged Idea (1)