Skip to main content

Power BI

Needs Votes

Epic idea: Apply filter selections automatically

Vote (4613) 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

Russ S. on 06 Jul 2020 00:01:35

RE: Epic idea: Apply filter selections automatically

We really need this, in a drop down list, I want to latest date to be selected,k after a refresh latest date selected, and when subscriptions go out, it should have this date.

Miguel Myers's profile image Profile Picture

Power BI Ideas Admin on 06 Jul 2020 00:01:22

RE: Epic idea: Apply filter selections automatically

We are still waiting for that ability !! We really need it

Miguel Myers's profile image Profile Picture

Subhrajit Ghosh on 06 Jul 2020 00:01:21

RE: Epic idea: Apply filter selections automatically

For example, in a date slicer by default StartDate and EndDate should be Today after each daily scheduled refresh.
This is a critical requirement.

Miguel Myers's profile image Profile Picture

Alexander Bromberg on 06 Jul 2020 00:00:53

RE: Epic idea: Apply filter selections automatically

We also require this feature for a lot of customer cases!

For example, we want to compare today's with yesterday's performance but the user should still be able to change the slicer date. Therefore a solution is highly appreciated without fixing the date manually.

Miguel Myers's profile image Profile Picture

A Power BI User on 05 Jul 2020 23:59:57

RE: Epic idea: Apply filter selections automatically

This is also a serious deficiency in being able to use RLS effectively. Right now a slicer will attempt to use a default value that has been filtered out by RLS (and thusly load no data into the report by default). That's ridiculous. Either Slicers need to correctly default to values they can actually utilize, or this could be implemented so that you could setup a DAX Measure that feeds a default slicer value based on what is available in RLS. There's a bunch of inelegant hacks around this right now that I would rather not implement.

Miguel Myers's profile image Profile Picture

Nikhil M on 05 Jul 2020 23:59:41

RE: Epic idea: Apply filter selections automatically

When our client opens the report after an overnight refresh, s/he would definitely like to see today's data as soon as the report is opened. Not yesterday's. Unfortunately, the slicer cannot be set to a default value of TODAY () and therefore this is a very important feature and I am surprised when its missing, after all these years.

Miguel Myers's profile image Profile Picture

Power BI Ideas Admin on 05 Jul 2020 23:59:33

RE: Epic idea: Apply filter selections automatically

I would find it very useful in a number of reports to be able to have a default value in a date slicer set to be today's date.

Miguel Myers's profile image Profile Picture

Power BI User on 05 Jul 2020 23:59:15

RE: Epic idea: Apply filter selections automatically

I need the ability to set a default relative date (e.g. the last 30days) but have the slicer sent to between. The relative date slicer does not work for many reports.

Miguel Myers's profile image Profile Picture

Pilar Sastre on 05 Jul 2020 23:59:08

RE: Epic idea: Apply filter selections automatically

I need to be able to default a date slicer to a "Current (time period)". And then give the user the ability to select another non-default item from the slicer, but it should default to the specified value when opened/reset.
This is highly needed!
Thanks!

Miguel Myers's profile image Profile Picture

Braden on 05 Jul 2020 23:59:05

RE: Epic idea: Apply filter selections automatically

Yes, this idea is critical. For example there are some reports where we would love to default the department to that user's department automatically. Having the ability to dynamically change the default would solve this. Similar to how it works in SSRS, you can return the value you want to use in another data set. I foresee where in Power BI you could do something similar. We have attempted to use Row level security and work around it by basically populating a table with every single possible slicer value for every user and then just setting the default to "My Dept." or something like that...but it's not very salable as more users start.

Merged Idea (1)