Forum Discussion
Chronological Schedule Section Table/chart
Hi All,
I'm trying to create something that resembles a geological chronological section in power bi, but struggling. I have to admit I have nothing of merit to post as 'what I have tried' because frankly nothing I have done has come close. I have tried Gantt charts and tables and matrixes. But falling pretty short of what i'm trying to achieve.
The data I have has start and end dates and then some text data associated with that.
My fall back is do a Python visualisation which I can probably do and perhaps is the only option, but wondered if there was anything more powerbi native that would achieve this look before I start writing something Pythonesq.
If anyone has any suggestions I would gladly hear them as i'm at a loss - or put me out my misery and say it's not possible in powerBi is also absolutely fine!
This is kind of what I want to get to (mocked up data below)
| start | stop | name | animal |
| 01/07/2022 | 20/10/2022 | Fluffy | dog |
| 21/10/2022 | 15/12/2022 | Milo | dog |
| 16/12/2022 | 23/02/2023 | Mittens | cat |
| 24/02/2023 | 09/03/2023 | Hairy | dog |
| 10/03/2023 | 11/07/2022 | Paws | cat |
3 Replies
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