Forum Discussion
Chronological Schedule Section Table/chart
Hi Anonymous ,
I created a sample pbix file(see attachment) for you, please check whether Gantt 2.2.3 is what you want.
Using a Power BI Gantt Chart for Project Management
Managing projects with multiple phases in Power BI using Gantt Chart
Best Regards
Hey Rena,
Thanks for that - in some ways I think we have been on the same path. What you have there is great, but perhaps my mocked data didn't quite do the problem justice.
For you second screen shot the problem would be the longer the dataset the larger that 'legend' list would get. 99% of items in this list are unique names.
The issue with perhaps both screen shots is that the scale you have used for my requirements is too wide, ideally it needs to be a quick look up at a narrowish monthly column. Using a slightly better exagerated mock set of data you can see that when the start/stops are around a week apart and the data is display by month the columns all roll in to each other.
For that reason in my 'fake' example of an end goal the writing was vertical so that it would slot in to a column.
I'm fairly certain there are no formating options like that in Gantt 2.3.3. I don't think it will even let the labels go below a size 8 font. For that reason I don't think it will achieve something like this -
Thanks for your time though, if you have any other thoughts please let me know - as I said thought I suspect I need to turn to python to get what I need.
| start | stop | name | animal |
| 01/07/2022 00:00 | 16/07/2022 00:00 | Fluffy | dog |
| 17/07/2022 00:00 | 30/07/2022 00:00 | Milo | dog |
| 31/07/2022 00:00 | 13/08/2022 00:00 | Mittens | cat |
| 14/08/2022 00:00 | 27/08/2022 00:00 | Hairy | dog |
| 28/08/2022 00:00 | 10/09/2022 00:00 | Paws | cat |
| 11/09/2022 00:00 | 16/09/2022 00:00 | spot | dog |
| 17/09/2022 00:00 | 22/09/2022 00:00 | fang | dog |
| 23/09/2022 00:00 | 28/09/2022 00:00 | whiskers | cat |
| 29/09/2022 00:00 | 04/10/2022 00:00 | floppy | dog |
| 05/10/2022 00:00 | 10/10/2022 00:00 | noisy | cat |
| 11/10/2022 00:00 | 16/10/2022 00:00 | smelly | dog |
| 17/10/2022 00:00 | 22/10/2022 00:00 | lassie | dog |
| 23/10/2022 00:00 | 28/10/2022 00:00 | Tom | cat |
| 29/10/2022 00:00 | 03/11/2022 00:00 | Scooby | dog |
| 04/11/2022 00:00 | 09/11/2022 00:00 | a12345 | dog |
| 10/11/2022 00:00 | 15/11/2022 00:00 | a12346 | dog |
| 16/11/2022 00:00 | 21/11/2022 00:00 | a12347 | dog |
| 22/11/2022 00:00 | 27/11/2022 00:00 | a12348 | dog |
| 28/11/2022 00:00 | 03/12/2022 00:00 | a12349 | dog |
| 04/12/2022 00:00 | 09/12/2022 00:00 | a12350 | dog |
| 10/12/2022 00:00 | 15/12/2022 00:00 | a12351 | dog |
| 16/12/2022 00:00 | 21/12/2022 00:00 | a12352 | dog |
| 22/12/2022 00:00 | 27/12/2022 00:00 | a12353 | dog |
| 28/12/2022 00:00 | 02/01/2023 00:00 | a12354 | dog |
| 03/01/2023 00:00 | 08/01/2023 00:00 | a12355 | dog |
| 09/01/2023 00:00 | 14/01/2023 00:00 | a12356 | dog |
| 15/01/2023 00:00 | 20/01/2023 00:00 | a12357 | dog |
| 21/01/2023 00:00 | 26/01/2023 00:00 | a12358 | dog |
| 27/01/2023 00:00 | 01/02/2023 00:00 | a12359 | dog |
| 02/02/2023 00:00 | 07/02/2023 00:00 | a12360 | dog |
| 08/02/2023 00:00 | 13/02/2023 00:00 | a12361 | dog |
| 14/02/2023 00:00 | 19/02/2023 00:00 | a12362 | dog |
| 20/02/2023 00:00 | 25/02/2023 00:00 | a12363 | dog |
| 26/02/2023 00:00 | 03/03/2023 00:00 | a12364 | dog |
| 04/03/2023 00:00 | 09/03/2023 00:00 | a12365 | dog |
| 10/03/2023 00:00 | 15/03/2023 00:00 | a12366 | dog |
| 16/03/2023 00:00 | 21/03/2023 00:00 | a12367 | dog |
| 22/03/2023 00:00 | 27/03/2023 00:00 | a12368 | dog |