Forum Discussion
Need to develop Plan view dashboard using the data from Jira
- Anonymous1 year ago
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.
Data
- Anonymous1 year agoNot applicable
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.
- Deelip_burla1 year agoFrequent Visitor
Hi There are there different kinds of Deneb visuals , which one i need to consider.
- Anonymous1 year agoNot applicable
Hi Deelip_burla,
The one on the left-most side, that’s the official Deneb visual built on Vega-Lite and Vega, and it’s the one that allows full control over custom visuals like the Gantt layout we're building.