The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hey guys!
I have a interesting, but probabbly simple for most of you, task that i would like to get landed but got stuck. I would like to visualise workflow based on data sett from excel, where each prosess takes given time in minutes and has expected end time.
My challenge is that i would like to add system time bar(?) which shows nowtime. I would like that raport would move to the right and down based on nowtime, something like in a picture below (red vertical line). My datasett is very simple. Adding it down below.
Would really appreciate any kind of help in this case!
Thanks in advance!
Batch NrProduktDurationStart timeEnd time
1 | FP kaker 52% | 00:10:00 | 05:30 | 05:40 |
2 | FP kaker 52% | 00:10:00 | 05:45 | 05:55 |
3 | FP kaker 52% | 00:10:00 | 06:00 | 06:10 |
4 | FP kaker 52% | 00:10:00 | 06:15 | 06:25 |
5 | FP kaker 52% | 00:10:00 | 06:30 | 06:40 |
6 | FM kaker 65% | 00:13:00 | 06:45 | 06:58 |
7 | FM kaker 65% | 00:13:00 | 07:03 | 07:16 |
8 | FM kaker 65% | 00:13:00 | 07:21 | 07:34 |
9 | FM kaker 65% | 00:13:00 | 07:39 | 07:52 |
10 | FM Boller | 00:10:00 | 07:57 | 08:07 |
11 | FM kaker 65% | 00:13:00 | 08:12 | 08:25 |
12 | FM kaker 65% | 00:13:00 | 08:30 | 08:43 |
13 | FM kaker 65% | 00:13:00 | 08:48 | 09:01 |
14 | FM Boller | 00:10:00 | 09:06 | 09:16 |
15 | FM kaker 65% | 00:13:00 | 09:21 | 09:34 |
16 | FM kaker 65% | 00:13:00 | 09:39 | 09:52 |
17 | FM Boller | 00:10:00 | 09:57 | 10:07 |
18 | FM kaker 65% | 00:13:00 | 10:12 | 10:25 |
19 | FM kaker 65% | 00:13:00 | 10:30 | 10:43 |
20 | FM kaker 65% | 00:13:00 | 10:48 | 11:01 |
21 | FM kaker 65% | 00:13:00 | 11:06 | 11:19 |
22 | FM kaker 65% | 00:13:00 | 11:24 | 11:37 |
23 | FM kaker 65% | 00:13:00 | 11:42 | 11:55 |
24 | FM kaker 65% | 00:13:00 | 12:00 | 12:13 |
25 | FM kaker 65% | 00:13:00 | 12:18 | 12:31 |
26 | FM kaker 65% | 00:13:00 | 12:36 | 12:49 |
27 | FM kaker 65% | 00:13:00 | 12:54 | 13:07 |
28 | FM kaker 65% | 00:13:00 | 13:12 | 13:25 |
29 | FM kaker 65% | 00:13:00 | 13:30 | 13:43 |
30 | FM kaker 65% | 00:13:00 | 13:48 | 14:01 |
Hey MFelix and thank you for your answear!
I have checked all of Gantt charts available and unfortunately non of them provide possibility to add an X axes where i could put in a measure =NOW() which should help med. Was thinking maybe someone has some workarrounds on this.
Hi @FreX ,
Try to check if the Gant Charts on the AppSource can be an option for your needs, there are several ones available with different options.
https://appsource.microsoft.com/en-us/marketplace/apps?product=power-bi-visuals&search=gant&page=1
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @FreX ,
Try to check if the Gant Charts on the AppSource can be an option for your needs, there are several ones available with different options.
https://appsource.microsoft.com/en-us/marketplace/apps?product=power-bi-visuals&search=gant&page=1
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsUser | Count |
---|---|
81 | |
81 | |
37 | |
34 | |
31 |
User | Count |
---|---|
94 | |
80 | |
60 | |
50 | |
49 |