Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Here's what the visual should look like (with a technician and date selected):
Thnaks! I'll check it out.
Search Youtube for the following:
I believe this video by Bas gives very clear and concise instructions to do this.
Hope this helps.
Regards,
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
94 | |
77 | |
65 | |
53 |
User | Count |
---|---|
145 | |
105 | |
104 | |
90 | |
63 |