Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
Need to develop Plan view dashboard using the data from Jira
And it should like the below, is it possible to develop the dashboard in the below format
But in Gnatt chart i can only have the bars in this way only, but i require the bars showing Epics side by side as per the screenshot.
How can i acheive that
Hi @Deelip_burla,
Most Gantt chart visuals in Power BI stack bars vertically for each task or epic, but don’t support showing multiple epics side by side on the same horizontal line (i.e., swimlane-style like in Jira Advanced Roadmaps).
If your goal is to display multiple epics aligned horizontally per team (just like PLAT, IOS, ADR in your screenshot), here are a few workarounds you can try:
* Use a Custom Matrix + Bar Chart Overlay. Here use a Matrix visual to group by team (rows) and month/week (columns). Then overlay a custom bar shape or conditional formatting using a separate bar chart or DAX-based logic to simulate side-by-side epics. This requires some creative layout work, its not perfect, but gives you flexibility.
* Try a Gantt Chart Visual that Supports Swimlanes. Some marketplace visuals like Gantt Chart by MAQ Software or Gantt Chart by Lingaro or xViz Gantt offer slightly more customization. You can try to group by both team and epic, which sometimes results in separate bars appearing on the same row depending on the data granularity.
* If you’re comfortable with custom visuals, Deneb allows you to build exactly what you're looking for using Vega-Lite/JSON. It gives you pixel-level control so you can draw Side-by-side bars or Milestone dots or Swimlanes per team. It’s more complex to set up, but gives results closest to Jira’s roadmap visuals.
Best Regards,
Hammad.
I am not getting excat solution from you, in ganntt chart only the bars can be shown in horizontal down not side by side. If you have any PBI template please share me. I will share you the sample data for the same.
Tribe Id | Tribe Name | EpicID | EpicName | TaskID | TaskName | StartDate | EndDate | Phase | Assignee Name | Team |
EWGEN-1007 | Castets Landes | EWGEN-1013 | Boiler Overview | EWGEN-1014 | Determine KOP targets | 4/1/2025 | 5/14/2025 | To Do | Unassinged | A |
EWGEN-1007 | Castets Landes | EWGEN-1013 | Boiler Overview | EWGEN-1015 | Identify & define Energy Opportunity | 4/1/2025 | 5/14/2025 | To Do | Unassinged | B |
EWGEN-1007 | Castets Landes | EWGEN-1013 | Boiler Overview | EWGEN-1016 | Create Energy Proposal | 4/1/2025 | 5/14/2025 | To Do | Unassinged | C |
EWGEN-1007 | Castets Landes | EWGEN-1013 | Boiler Overview | EWGEN-1017 | Define Usage Scenarios & Set responsibilites | 5/15/2025 | 5/31/2025 | In Progress | Unassinged | A |
EWGEN-1007 | Castets Landes | EWGEN-1013 | Boiler Overview | EWGEN-1018 | Prepare staff Training | 5/15/2025 | 5/31/2025 | In Progress | Unassinged | B |
EWGEN-1007 | Castets Landes | EWGEN-1012 | Process Steam | EWGEN-1024 | Determine KOP targets | 4/1/2025 | 5/17/2025 | To Do | Unassinged | C |
EWGEN-1007 | Castets Landes | EWGEN-1012 | Process Steam | EWGEN-1025 | Identify & define Energy Opportunity | 4/1/2025 | 5/17/2025 | To Do | Unassinged | A |
EWGEN-1007 | Castets Landes | EWGEN-1012 | Process Steam | EWGEN-1026 | Create Energy Proposal | 4/1/2025 | 5/17/2025 | To Do | Unassinged | B |
Hi @Deelip_burla,
Thanks for following up with the conversation, that really helps clarify what you're aiming to do.
You're absolutely right with standard Gantt visuals in Power BI (like the ones from AppSource) don't support placing bars side by side on the same horizontal level by default, they stack tasks vertically instead. If you want each epic or team to have a single row with side-by-side bars representing tasks, we’ll need to use a different approach.
Here’s how you can achieve that layout. Use the Deneb visual (available from AppSource). Deneb gives you full control to build a custom Gantt layout, and it supports drawing multiple bars on a single row, which is what you're looking for.
With the data you shared (tribe -> epic -> task with start/end), Deneb can plot each TaskName as a bar on a timeline, grouped by EpicName or Team, all in one horizontal row.
Best Regards,
Hammad.
Hi @Deelip_burla,
Thanks for reaching out to the Microsoft fabric community forum.
It looks like you want to replicate advanced roadmaps plan view to create a similar Plan View dashboard using Jira data. As @Poojara_D12 already responded to your query, kindly go through his response and check if it answers your query.
I would also take a moment to thank @Poojara_D12, for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.
If I misunderstand your needs or you still have problems on it, please feel free to let us know.
Best Regards,
Hammad.
Community Support Team
If this post helps then please mark it as a solution, so that other members find it more quickly.
Thank you.
Yes, it is possible to develop a Plan View dashboard in Power BI similar to the one shown in your Jira screenshot, but it requires careful data extraction and visual customization. The image represents a typical roadmap or Gantt-style view from Jira Advanced Roadmaps, displaying project timelines, team-based swimlanes (like PLAT, IOS, ADR), and tasks or epics plotted across a calendar timeline with color-coded bars and milestone markers. To replicate this in Power BI, you first need to extract structured data from Jira using the Jira REST API or a third-party Power BI connector, capturing key fields such as issue IDs, summaries, statuses, start and end dates, story points, teams, and releases. Once the data is modeled correctly, you can use a Gantt chart custom visual from AppSource to replicate the timeline view. The tasks or epics can be grouped by team or project to create the swimlane effect, and releases can be shown using markers or shapes depending on the visual's capabilities. Below the timeline, a table can be added to list the scope with issue keys, descriptions, story points, and statuses—just like in the screenshot. While Power BI doesn’t natively support a full roadmap view like Jira Portfolio, with proper data modeling, a suitable Gantt chart visual, and some formatting logic, you can create a close and interactive replica of this layout for reporting and project tracking.
User | Count |
---|---|
14 | |
6 | |
2 | |
2 | |
2 |
User | Count |
---|---|
3 | |
3 | |
3 | |
2 | |
2 |