Forum Discussion
Single day date slicer
Hello
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
13 Replies
Hello
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
This is it. This question here Microsoft. The fact that you don't seem to understand how simple this is...is baffling. Do you even know how simple this would be to implement? GIVE US THE "ON" option the Style list.
Real, real simple. Not sure how you're missing all these posts that a simple search shows: you are FAILING to provide a single date selection slider and the insult here is how many other convoluted ways you DO provide. Check out how convoluted Relative Date and Relative Time are.
Meanwhile, a lot of folks just want to have a single date selection slider.
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%
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，
Cherry
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
Here a short description how this can be achieved. Hope this helps 🙂
I see you with the same reply across multiple posts asking for a single date picker from a calendar visual. The point is doing this should not be this hard. We shouldn't have to go through so many steps just to come up with a slicer. Thats spending a lot of time and energy just to configure a slicer instead of reporting items.
I agree that it would be good if it is offered out of the box. Since this is not yet the case, it does not mean that there is not a way to the solution or no answer to the initial question.
