Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
ajin
Helper II
Helper II

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
v-yuta-msft
Community Support
Community Support

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

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 

parry2k
Super User
Super User

@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.



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

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 . 

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.