- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Display data between 2 dates (not exclusive) for Gantt Chart
Hello community! I am running into a problem I can't seem to find the solution to, even after a lot of research and trials.
I have machine activity data. For example
MachineName | StartDate | EndDate | Status |
A | 2021-06-08 10:00:05 | 2021-06-08 12:10:00 | Active |
A | 2021-06-08 12:10:01 | 2021-06-08 1:32:12 | Paused |
B | 2021-06-08 9:00:00 | 2021-06-08 9:23:02 | Active |
The goal is to display this info on a Gantt chart where we would see every machine and their status on a timeline (see example below).
My issue is with time intelligence. There will be a calendar filter on the page and I want, for example, if we filter on "From 2021-06-08 8:59:00 To 2021-06-08 11:00:00, that part of the activity of Machine A to show up and also Machine B's activity to be displayed.
Here is a sample of my data:
Thanks in advance!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @Anonymous ,
You could create a measure use IF() function. If the Machine is active then measure =1 else measure =0. At last add this measure to visual filter.
Best Regards,
Jay
If this post helps, then please consider Accept it as the solution to help the other members find it.
Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Microsoft Fabric Community Conference 2025
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
Subject | Author | Posted | |
---|---|---|---|
01-05-2024 11:21 AM | |||
05-27-2024 02:45 AM | |||
07-25-2023 03:21 AM | |||
07-03-2024 03:10 AM | |||
10-20-2023 01:19 PM |
User | Count |
---|---|
120 | |
73 | |
58 | |
57 | |
43 |
User | Count |
---|---|
179 | |
120 | |
82 | |
68 | |
56 |