Technical feasibility and Tips -- Help about my project

[hsavy]

Hello everyone, 

I have a project of a visualization of two schedules agreement on different task and would want to reproduce the following model in a custom visual (I can't find how to do it properly with the available visuals). 
I would like to know its technical feasibility and would welcome any advice on how should I do it as I am a newbie 🙂 

Model : 

I am an engerneering student in computer science so I'm used to programming and I have few knowledges on web technologies.
I have also already took a look to Microsoft and youtube tutorials to create custom visuals. 

Thank you to anyone answering and feel free to question me back ! 
hsavy

[giammariam]

If you could provide a sample .pbix file with sample data, I'd be happy to help.

[hsavy]

Hey sure, they won't let me upload any .xlsx or .pbix file so here is a data sample : 

Subsys	Date 1	Date 2	Date 3	Date 4
Task 1	01/01/2022	01/01/2023	02/02/2023	10/10/2023
Task 2	01/01/2022	01/05/2023	02/02/2023	10/12/2023
Task 3	05/05/2022	05/05/2023	01/01/2023	12/12/2023
Task 4	01/01/2022	01/01/2023	02/02/2023	10/10/2023
Task 5	01/01/2022	01/05/2023	02/02/2023	10/12/2023
Task 6	05/05/2022	05/05/2023	01/01/2023	12/12/2023
Task 7	03/03/2022	09/09/2022	03/03/2023	09/09/2023
Task 8	05/05/2022	12/12/2022	05/05/2023	12/12/2023

Let me know on how to upload one if you need me to. 

[lbendlin]

If you like you can experiment with generating your own data series for these tasks, and then use a standard matrix visual to blend it all together.  Might be a bit messy as you seem to need day level granularity.

Also have a look at Deneb or Charticulator.

[hsavy]

Thank you for answer. Indeed, I've achieve it with matrix visual but it's messy and can't be modified as much as a custom visual can. 
I've read a lot about creating a custom visuals with Typescript and react. I've found a couple of great libraries to use such as vis-timeline, a fully scalable scrolable timeline, to use to create my custom visual. 

Do you think it is possible to create something this way with PowerBI SDK ?  

[lbendlin · Accepted solution]

Before you go that deep have a look at this video by @ppm1  - it uses Deneb.

Deneb Demo Build - Gantt Edition - YouTube

[giammariam]

Agree, I was actually going to generate a Vega-Lite spec and throw it into deneb to see if it'd give @hsavy what they wanted

[lbendlin]

I am doing the same, always wanted to understand what x2 is about - why don't we have a friendly competition...

We'll have to slightly massage the sample data - groupwise unpivoting is fun!

[hsavy]

Thanks to both of you guys, I didn't knew about Deneb and was a bit lost. It will definetly make the job ! 
Don't bother about giving me the spec, I will find a way throught it (if not i may ping you 🙂 ) 

[giammariam]

@hsavy feel free to ping if you get stuck, but Deneb is definitely worth learning in my opinion. Building out custom visuals using the API is a lot of work but allows for full control, and is especially useful if you want your visual to be available to other report authors that may not want to jump into declarative coding. Deneb has drastically reduced my need to develop full-scale custom visuals.

@lbendlin, I may build it out when I have time (a bit busy today) and just send my spec to you for feedback and to compare notes/implementations. The idea of a friendly competition did sound fun though