cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ConnieMaldonado
Helper V
Helper V

Date SLICER default value upon report entry

Hello - I am using a Gantt chart visual (as Timeline) to display time clock, drive time, and actual work data for field technicians.  The visual helps supervisors quickly identify issues with paid hours and actual time in the field (for each tech).  The supervisor will select a technician and date and review activity on that day.  There are other slicers to guide the selection (such as Site Manager, Field Tech Supervisor).

 

The issue is that upon entering the report, the visual shows all the data (until you make your selections).  In the date slicer, I only allow one date which is automatically defaulting to the earliest date in the table.  I would like to prepopulate it with yesterday's date as a starting point (but still allow the user to select other dates.)  Is there a way to do that?  For the date slicer, I am using the date field for the individual activities.

 

My ideal solution would be to NOT populate the timeline visual until the user selects a technician.  I will eventually have a performance issue as data accumulates, so I may have to limit data to the last 90 days.  Thanks!

 

Date image.png

Here's what the visual should look like (with a technician and date selected):

 

Date 2.png

2 REPLIES 2
ConnieMaldonado
Helper V
Helper V

Thnaks!  I'll check it out.

rsbin
Super User
Super User

@ConnieMaldonado,

Search Youtube for the following:

How to set a DATE SLICER to TODAY by default in Power BI

I believe this video by Bas gives very clear and concise instructions to do this.

Hope this helps.

Regards,

Helpful resources

Announcements
May 23 2022 epsiode 5 without aka link.jpg

The Power BI Community Show

Welcome to the Power BI Community Show! Jeroen ter Heerdt talks about the importance of Data Modeling.

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through June10th!

Power BI Dev Camp Session 22 with aka link 768x460.jpg

Check it Out!

Join us on Thursday, May 26 at 11a PDT for a great session with Ted Pattison!

Power BI Release May 2022 768x460.png

Check it out!

Click here to read more about the May 2022 updates!

Top Kudoed Authors