Power BI - Gantt chart based on date and time

[Anonymous]

Hi Team,

We are currently looking for a gantt chart that should report hourly ( time and day ) based on progress and status. Most of the gnat charts available in the markets are showing reports based on day and month based. Please suggest a visual to use in Power BI. 

Regards,

Saveesh.S

[Ritaf1983]

Hi @Anonymous 
The most flexible Gantt charts that I know are from matrixes.
You can just use hierarchies and have a date and time.
Take a look at these tutorials:

https://www.youtube.com/watch?v=SO4mk1H94OA

https://www.youtube.com/watch?v=QugkBqc-jIs&t=917s

https://www.youtube.com/watch?v=8pbFvBMT9L8&t=260s

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[Anonymous]

I have tried the matrix approach using a date and time value and the matrix is  shwoing only one colum for date & time field. But if I add a date column it shows for all the existing date values. 

Please find the screen shot below. 

[Ritaf1983]

Hi @Anonymous 

Try to play with hierarchies something like those:

You can download my example from: Here 

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[amitchandak · Accepted solution]

@Anonymous , check if one of these Gantt chart support what you need

https://appsource.microsoft.com/en-us/marketplace/apps?search=Gantt%20Chart&page=1

[Anonymous]

Thanks for the response. 
I found - Find the right app | Microsoft AppSource is one of the suitable one for my case. Used it and waiting to get the license detaisl and preset to the customer. Thanks for you help. 🙂