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

Single Date filter selection issue

Hi All, 

we have a requirement to display single date filter option for user to select date and filter the reports accrodingly. 

Currently we see when we set single selection option either in date slicer or in filter pane, we see only drop down list and not a calendar pop out. Whereas for date slicer with betwee/after/before options we have calendar pop out option. 

 

Users are not happy to scroll down the list through hundreds of rows to select the date filter they want. 

 

Is there a custom slicer view that i can download and use? or any work around to display calnedar pop out for single date selection?

Any help is greatly appreciated! 

I have already seen the GuyintheCube's video released in May, and he is calculating each metric by passing the selected date as filter using variable. That will not work for me, as i am displaying calculated MTD measures in my report. Also, his option might impact the performance. 

https://www.youtube.com/watch?time_continue=184&v=zhWtU0DynCk&feature=emb_title

 

-

Thanks

Shilpa

 

2 REPLIES 2
Highlighted
Super User IV
Super User IV

@sspowerbi , there is timeline slicer, but it looks too big

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



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Highlighted
Community Support
Community Support

Hi @sspowerbi ,

Please try the methods in the following blog and check if it can achieve your requirement:

Using a Single Date Picker with Conditional Filtering in Power BI

In addition, here is one similar idea shared on Power BI Ideas , you can vote it up and add your comments there to improve Power BI on this feature.

Best Regards

Rena

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors