Chronological Schedule Section Table/chart

[Anonymous]

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

[v-yiruan-msft]

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

[Anonymous]

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

[Anonymous]

Ok I will add one image of how close I got with a Gantt chart...but all the words merge in to each other because sadly the formatting for the 'gantt' widget isn't quite flexible enough for the scale I want to display at.