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)
- Merged Idea (1)
RE: Epic idea: Apply filter selections automatically
We really need the default date range set into slicer. It is very needed on my all reports.
RE: Epic idea: Apply filter selections automatically
Not sure, if i am writing this at correct place. If no, i am sorry but i don't know where to raise it.
I have below user's data. I have setup RLS
User Product
User1 Product 1
User1 Product 2
User1 Product 3
User2 Product 4
User2 Product 5
User2 Product 6
I want, "Product 1" should be default selection when User1 logged in and "Product 4" default selection for when User2 logged in. In other words, first valid value per user should be selected. Can we do this in Power BI? Please let me know.
RE: Epic idea: Apply filter selections automatically
I, too, need the ability to have date slicers in my reports default to the latest/max date (which is not necessarily today or yesterday).
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.
RE: Epic idea: Apply filter selections automatically
We are still waiting for that ability !! We really need it
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.
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.
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.
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.
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.