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

date slicer in current date

Hi Guys,

 

Is there a way tht i can default my date slicer to current date/todays date. ( the date column should remain a date value) I saw some posts where text is added through dax and user has to select current date. i would'nt wanna be doing that since i think the field has to be converted to text. 

 

Thanks 

Aj 

4 REPLIES 4
Super User
Super User

Re: date slicer in current date

@ajin if you use date as relative fitler in filter pane then you can check mark to include today's date but from you question sound like you want to use date slicer.






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

Proud to be a Datanaut! Appreciate your Kudos Smiley Happy
Feel free to email me with any of your BI needs.





ajin Regular Visitor
Regular Visitor

Re: date slicer in current date

Hi @parry2k,

 

Yup, the user would wanna use the  date slicer.  My scenario is when the user logins in to the report he has to see the values of to date at current date value. Further if he wants to change the date to another  date he can . 

Community Support Team
Community Support Team

Re: date slicer in current date

Hi ajin,

 

I have found a workaround for your requirement. https://community.powerbi.com/t5/Desktop/Setting-the-Default-Value-of-a-Slicer/m-p/16442

 

Regards,

Jimmy Tao

Highlighted
ajin Regular Visitor
Regular Visitor

Re: date slicer in current date

Hi @v-yuta-msft,

 

I wouldnt consider this as a workaround for the issue. Since those are not in date format. i would be using a date range slicer ( between). 

 

Thanks 

Ajin 

Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 316 members 3,276 guests
Please welcome our newest community members: