Showing results for 
Search instead for 
Did you mean: 
Regular Visitor

Single day date slicer



Is there a way to filter information using only one date argument?


Like using a normal date slicer but with only one date picker.


I used relative day filtering and works well, i just want that my report is more user-friendly



New Member

This is the biggest reason people (IT Director(s)) are moving from Power BI.  It is one of the top expected functionality items, period.   Currently this expected and demanded functionality is horded to some MS developer that is selling the Custom Made controll.  Honestly I may suggest trashing this platform as its rediculous and 90% of my development time is going twords telling all the business people that this is not avilable and MS is forcing us to use the Filter pane - and you have to use and toggle and learn and teach every user how to use the slicers / filter pane.


Failure 100%

Resident Rockstar
Resident Rockstar

Hi @isaacRLS,



If I understand your requirement correctly, you want to select a single date in date Slicer to filter other information?


If you have a date column, you could create a Date list Slicer and turn on the single selection in the format pane.


The picture below should be your expected output.




If you need additional help please share your expected output.


Best Regards,


Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi @v-piga-msft


Yes that was i looking for, but I was wondering if there is a way to keep using the date picker from the calendar or maybe a custom visual.


I also have in mind use the between date slicer, and made a formula to automatically change the dates. i.e. if user change the start date, then copy the start date into the end date

@isaacRLS  : did you solve the below thread by writing formula to select the start date from end date ?. If yes can you share the steps please

Not applicable



I need exactly the same behaviour: Just pickup a single day from a visual calendar... it's possible between two date with the "Between" choice. For the moment I use the "dropdown list" choice in a segment but it's not efficient and friendly when you have 3 years and more of data...





@Anonymous : this is not available currently

Regular Visitor



Is there a way to pick a single day and filter out the information?


I don't want an start and end date. Just one date input




Helpful resources

PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

Top Solution Authors
Top Kudoed Authors