Skip to main content

Power BI

Needs Votes

Epic idea: Apply filter selections automatically

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

IT on 05 Jul 2020 22:37:30

RE: Epic idea: Apply filter selections automatically

Yes this is really needed.

Miguel Myers's profile image Profile Picture

Power BI User on 05 Jul 2020 22:37:22

RE: Epic idea: Apply filter selections automatically

really needed to show default date as current month date range.

Miguel Myers's profile image Profile Picture

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

RE: Epic idea: Apply filter selections automatically

The preselected slicer value would also drastically reduce DB usage when a power BI report is connected to DB via DirectQuery. Currently we have a situation when user goes to report page and whole data is accessed before user select the dates he wan't to look at the date. This inceases the DB load by over 10x since normally user is interested on specific date data (not whole year...)

Miguel Myers's profile image Profile Picture

Nick D Martin on 05 Jul 2020 22:35:55

RE: Epic idea: Apply filter selections automatically

On a multi-tab report, this is an issue that can really get in the way of a user's flow. I receive emails all the time that a page is displaying the wrong metrics; when in actuality, the user has not updated their slicer to reflect the most current month when they switched tabs. If a user does not have a pleasant experience, there is less of a chance of them using your report.

Miguel Myers's profile image Profile Picture

Chris Brawley on 05 Jul 2020 22:33:30

RE: Epic idea: Apply filter selections automatically

This feature is important for viewing large data sets. Our example is that for a Region Sales Manager, he wants to look at store by store performance. Seeing all sellers at all stores is not useful. We want to default the chart to show all sellers at the first store (alphabetically) in his region so that the bar chart with sales performance information only shows 10-15 bars instead of hundreds which is not useful and is very visually unappealing

Miguel Myers's profile image Profile Picture

Riyan on 05 Jul 2020 22:30:50

RE: Epic idea: Apply filter selections automatically

I agree,
this feature will very useful.

Miguel Myers's profile image Profile Picture

phillip786 on 05 Jul 2020 22:29:24

RE: Epic idea: Apply filter selections automatically

Yes this is needed in the case where you have data that if not filtered doesn't present useable data

Miguel Myers's profile image Profile Picture

Aaron Shumaker on 05 Jul 2020 22:26:29

RE: Epic idea: Apply filter selections automatically

Another reason to have a default selection and not allow "All" for a slicer is sometimes we have reports that are reporting on a very detailed level that you would want to force the user to slice to avoid overly large queries.

Miguel Myers's profile image Profile Picture

Power BI User on 05 Jul 2020 22:25:42

RE: Epic idea: Apply filter selections automatically

I currently assessing Power BI as an alternative to an interactive excel worksheet but not having this option has limited the applications usefulness.

Miguel Myers's profile image Profile Picture

Wenchi Wang on 05 Jul 2020 22:22:06

RE: Epic idea: Apply filter selections automatically

yes, please allow to set default value for the slicer. It would be nice to have a calendar visual as a date slicer.

Merged Idea (1)