Forum Discussion

shivansh_2003's avatar
shivansh_2003
Regular Visitor
9 months ago
Solved

Choice for a Gantt Chart

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 consist...
Need Help
  • Zanqueta's avatar
    Zanqueta
    9 months ago

    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 🌀.

Zanqueta's avatar
Zanqueta
Icon for Super User rankSuper User
9 months ago

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 🌀.