I want to set default filter of this week to slicer.However ,every answer use the option list.(i.e. if(weeknum(now())=weeknum([mydate]),"current week",[mydate]).
I selected the bar and choose start date with end date to filter date.On the previous way it's work on option-list but not on bar.
Can you try explaining this again, I'm not getting what your issue is. Not sure what "on bar" refers to for example.
Proud to be a Datanaut!
You picture is bar slicer rether than list. You can drag the ending button to adjust your date range. What's your requirement? Could you please descirbe clearly? Or you have resolved your issue by youself? If it is, please share the solution or mark the corresponding reply as answer.
What's your problem, please feel free to ask. Based on my understanding, you create a slicer with a bar like the picture you posted. You can select the date scope in the slicer.
I just found this post in google. I think @RachC is looking for the same thing than me, how to pass dynamically a value to the slicer. For example, I would like the bar slicer goes from 01/01/2017 (1st day of current year) to today, all this dynamically.