Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi all,
Very simple question, but I'm (suprisingly) unable to find a solution from other topics.
I need a date slicer (between-mode) that selects the most recent 14 days by default... while still allowing end-users to pick any other period (for both start and end dates).
From what I've seen, this is impossible to accomplish in PowerBI. Is that true?
Solved! Go to Solution.
@vanessafvg Ah, I now understand what you mean. The problem is that I wasn't planning to let those end-users in one the filter-pane on the right, because I believe they won't like that (they are very stubborn and not tech-savvy at all so they will probably find it difficult to use). I have it hidden right now.
But this notion is making me rethink that decision. If that's the only way to do it.. I might have to.
Thanks!
A few years later, but I haven't found a solution to set the defaults values of a date slicer dynamically. But I found another work around that worked for me and thought I would share here.
I created 2 date slicers: one relative date slicer, that will be my "Default state", and one date selector slicer that will allow users to pick whatever date range they would like to see.
Note: important to make sure the bookmarks not only hide / show appropriate slicers, but also reset the dates on the one being hidden.
See below of the report with both "states" of the slicer.
@zudar Does you accomplished this task?
I'm on the exact same problem as you, still not fouding anything that works on it :S
No, I didn't accomplish it, unfortunately..
Hello,
Is it still the case that it's impossible to have a Between slicer that defaults to let's say last 30 days BUT allows the user to select any start/end dates with date pickers and WITHOUT accessing the filter panel in any way? It seems like a major drawback not to have such feature. We have clients that have been asking this for ages...
@lehikk
Yeah, as far as I understand, that's not possible.
I've created a report for my company that will be shared with external clients as well and this is really something I'm having trouble with explaining to colleagues. At this point I just edit the report every now and then to select the most recent period and save it like that.. it's quite sad actually. 🙂
@zudar , you have date slicer which can be made as range and you have relative date slicer
https://docs.microsoft.com/en-us/power-bi/visuals/desktop-slicer-filter-date-range
Or but a custom for a case like this
https://www.youtube.com/watch?v=duMSovyosXE
@amitchandak I think both solutions are not exactly what I need. I could be wrong on the second one, but the way the video was introduced doesn't sound like my requirement.
When my end-user opens the report, I want the most recent 14 days to be selected. After that, he/she should be free to select any start- and end date. Could be 100 days in the 1980's, for all I care. 😁
I think this is just impossible to accomplish..
it is possible if i understand you correctly, all you need do is select the relative filter on the visual slicer
Proud to be a Super User!
Hi! When I do your solution, my visuals doesnt change. Can you help me?
@vanessafvg The issue using that solution is that the slicer is then restricted to only (for example) the most recent 14 days. I want my end-users to be able to select any date range they want.. but that when they open the report, the most recent 14 days are selected by default.
Proud to be a Super User!
@vanessafvg Ah, I now understand what you mean. The problem is that I wasn't planning to let those end-users in one the filter-pane on the right, because I believe they won't like that (they are very stubborn and not tech-savvy at all so they will probably find it difficult to use). I have it hidden right now.
But this notion is making me rethink that decision. If that's the only way to do it.. I might have to.
Thanks!
hi @zudar
Yes, Now when you log out of Power BI and come back to a report, the same items will be selected as when you left.
Best Regards,
Lin
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |