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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Single value slider for table containing just a date column

Hi,

 

Apologies if asked before, did search but didn't find something so suitable.

 

New to Power BI (love it!). Looking for a slider visual where I can move the marker or indicator left or right. The min date on left will be the oldest date in table,  max date on right the most recent. Moving slider will change date, picking one of the values, higher or lower, according to the possible list of dates in the table.  I dont need any yearly/quarterly/monthly/daily features - just setting the date from one of those available in my date table.

 

Many thanks in advance for any help or pointers!

 

I feel this would be a more compact 

6 REPLIES 6
amitchandak
Super User
Super User

@Anonymous , You can check for timeline slicer

https://appsource.microsoft.com/en-us/product/power-bi-visuals/wa104380786?tab=overview

 

Or try between option in slicer

Anonymous
Not applicable

Hi, I did try the timeline slicer but it proposes a timeline of dates for which I do not have data. Therefore, if I select a date on the timeline slicer where I dont have data tghe visualisations are rendered blank.  Similar issue with "between" I believe - a range of dates (I only want to pick one), and thatr picked date must exist in my date table. Thanks

Hi @Anonymous 

 

I didn't find a slicer visual close to what you need. Maybe you can refer to below links to create a date picker:

Build a DATE PICKER in Power BI Desktop - YouTube

NEXT LEVEL Power BI Date Picker! - YouTube

 

Otherwise you may try a custom visual Smart Filter, it is similar to a standard slicer but you can enter a date in the input box to select a single date.

121802.jpg121803.jpg

 

Community Support Team _ Jing Zhang
If this post helps, please consider Accept it as the solution to help other members find it.

Anonymous
Not applicable

Thanks so much for the proposals. I'm currently using the date picker with drop-down, but it's a bit clunky for the user when they quicly want toi flip between data snapshots. For the same reason the manual entry date selection would not work in this case. Do appreciate the suggestion though 🙂

AllisonKennedy
Super User
Super User

@Anonymous  Have you tried the 'between' option for the date slicer?


Please @mention me in your reply if you want a response.

Copying DAX from this post? Click here for a hack to quickly replace it with your own table names

Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C

I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com

Anonymous
Not applicable

Hi. I believe the between option still dictates a range of dates, the values of which are not limited to the "snapshot" dates I have i.e. I do not have data for every day, but for ad-hoc days. Therefore if I select a date for which data does not exist the visualisations become blank.  Thanks

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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