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

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
isaacRLS
Advocate I
Advocate I

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

 

 

12 REPLIES 12
torsten
Helper II
Helper II

Here a short description how this can be achieved. Hope this helps 🙂

pborah
Impactful Individual
Impactful Individual

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.

pborah
Impactful Individual
Impactful Individual

It's not really a solution. It's a workaround.

Correct, and this is how it is described at the end of the article. Still, a way to achieve the goal, even if a native solution is of course better.

Anonymous
Not applicable

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%

v-piga-msft
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.

 

Untitled.png

 

If you need additional help please share your expected output.

 

Best Regards,

Cherry

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

Anonymous
Not applicable

@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

Anonymous
Not applicable

Hi,

 

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

 

Rgds,

 

JEremy

Anonymous
Not applicable

@Anonymous : this is not available currently

isaacRLS
Advocate I
Advocate I

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

 

 

 

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

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

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

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