Choice for a Gantt Chart

[shivansh_2003]

I wanted to select a gantt chart for my powerbi dashboard, that has some functionalities like :

• I wanted to create timelines for the projects under different categories , so first column consists of category , then under it there are various projects and then comes the timeline for each of the projects based upon start and end date.
• Also I wanted the functionality of the mouseover , For Eg: if I hover on any project , it should show me the details for the project, like stakeholders, assigned person etc.
• Last but not least I wanted the clickable jira link  for all the projects to be included as a separate column or clickable headings of the projects in the gantt chart.
  
  Please can you help me suggesting which gantt chart will fuflfill all my requirements.

[v-prasare]

Hi @shivansh_2003,

We would like to confirm if our community members answer resolves your query or if you need further help. If you still have any questions or need more support, please feel free to let us know. We are happy to help you.

Thank you for your patience and look forward to hearing from you.
Best Regards,
Prashanth Are
MS Fabric community support

[v-prasare]

Hi @shivansh_2003,

We would like to confirm if our community members answer resolves your query or if you need further help. If you still have any questions or need more support, please feel free to let us know. We are happy to help you.

@Zanqueta, Thanks for your prompt response

Thank you for your patience and look forward to hearing from you.
Best Regards,
Prashanth Are
MS Fabric community support

[shivansh_2003]

@Zanqueta Actually I was using this gantt chart previously but there were two problems that I was facing with it :

1. These are the categories under which they have different projects, so I wanted the category doesn't get repeated and there would be like expand or collapse feature also , which will expand or collapse the projects. As in this way it doesn't look that clean. 

2. In this visual I cant find any option to include the url column , like hyperlink field that you have mentioned earlier. Is there any dashboard that you have implemeted these things, or if you can share the screenshot, it would be very helpful.

[Zanqueta]

Hi @shivansh_2003,

Maybe you can fix this steps in power query, but without see you data, it´s harder.

By the way, I guess is not possible included a link direcly in visual, you may insert a tooltip or a support table to achieve this.

Could you share a sample of data, few lines can be enouth to try reproduce you scenario.

If this answer was helpful in any way, I would be pleased to receive a 👍, as well as the satisfaction of seeing a DAX measure work for the first time without needing yet another FILTER.
Please mark it as the accepted solution. This helps other community members find the quickest path and saves them from another endless loop 🌀.

[shivansh_2003]

This is the chart I was using earlier which contains the category as product development and below are the various projects for the category . Is there any way to add the hyperlinks. 
This chart is Gantt 3.0.12.0 

[Zanqueta · Accepted solution]

Hi @shivansh_2003, thank you for you feedback.

Yes, I can. I assuming you already created the hiperlink column in power query, such indicated in previous post 

• Hyperlink field → Jira URL

After that you need to change a data category like this and put the new column in your table or in a tooltip page.

For reference: URL Hiperlink - Microsoft Fabric Community

Please, let me know if it worked.

If this response was helpful in any way, I’d gladly accept a 👍much like the joy of seeing a DAX measure work first time without needing another FILTER.

Please mark it as the correct solution. It helps other community members find their way faster (and saves them from another endless loop 🌀.

[shivansh_2003]

Thanks for your time . Its really appreciated. 

[Zanqueta]

Hi @shivansh_2003,

I'm not  100% sure, but currently, the default Power BI visuals do not provide a native Gantt chart with all these features, so you will need to use a custom visual from AppSource or a third-party solution.

The best option in my way – Microsoft Certified Visual: Gantt Chart by MAQ Software

• Features:
  • Supports hierarchical grouping (Category → Project).
  • Allows custom tooltips for additional details.
  • Provides hyperlink functionality for clickable links (e.g., Jira).
• How to implement:
  1. Install the visual from AppSource in Power BI Desktop.
  2. Prepare your dataset with columns:
     • Category
     • Project Name
     • Start Date
     • End Date
     • Stakeholders / Assigned Person
     • Jira URL
  3. Configure:
     • Task → Project Name
     • Parent → Category
     • Start Date / End Date → Timeline
     • Tooltip fields → Stakeholders, Assigned Person
     • Hyperlink field → Jira URL

Best Practice

• Ensure your data model includes all required fields in a single table for simplicity.
• Use custom tooltips to display project details without cluttering the chart.
• Validate that the Jira URL column is formatted as a hyperlink in Power BI.

If this answer was helpful in any way, I would be pleased to receive a 👍, as well as the satisfaction of seeing a DAX measure work for the first time without needing yet another FILTER.
Please mark it as the accepted solution. This helps other community members find the quickest path and saves them from another endless loop 🌀.