Forum Discussion
Setting a default value for 'between' date slicer
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?
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!
16 Replies
it is possible if i understand you correctly, all you need do is select the relative filter on the visual slicer
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.
- you can still manually change it.
Hi! When I do your solution, my visuals doesnt change. Can you help me?
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. 🙂
Anonymous , 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
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..
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.
How did you achieve the Icon fill? When I try to fill the icon it is getting filled in both the bookmarks 😞
