cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
RachC Regular Visitor
Regular Visitor

Setting the Default Value of a Slicer

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. 

any ideas?

7 REPLIES 7
Super User
Super User

Re: Setting the Default Value of a Slicer

Can you try explaining this again, I'm not getting what your issue is. Not sure what "on bar" refers to for example.


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


RachC Regular Visitor
Regular Visitor

Re: Setting the Default Value of a Slicer

bar.png

set "between" to slicer.

I didn't use language of English in Power BI that I can't refer to Proper nouns accurately.

v-huizhn-msft Super Contributor
Super Contributor

Re: Setting the Default Value of a Slicer

Hi @RachC,

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.

Thanks,
Angelia

v-huizhn-msft Super Contributor
Super Contributor

Re: Setting the Default Value of a Slicer

Hi @RachC,

Have you resolved your problem? 


Best Regards,
Angelia

RachC Regular Visitor
Regular Visitor

Re: Setting the Default Value of a Slicer

umm..sadly it's not.

I try to make m code to implement my goal.

v-huizhn-msft Super Contributor
Super Contributor

Re: Setting the Default Value of a Slicer

Hi @RachC

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.

Best Regards,
Angelia

manubust Frequent Visitor
Frequent Visitor

Re: Setting the Default Value of a 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. 


Kr,
Manuel