JIRA data drill down (Epic-->Story-->Task-->Sub Task

[danishs]

Hi Friends,

Softwares:

- JIRA On Premises

- Power BI Desktop

Issue:

I wanted a drill down Gantt chart where user will see all Epic and their status, Sprints, Dates etc. When user drill down to Epic, it should display all Stories under that Epic and its Status, Sprints, Dates etc. Similarly, if user drill down in Story, it should display all Task etc.

Currently I didn't find this trelation parent child relation between Epic, Story and Task (Except Task and Sub Task). 

Solutions:

- Should I import JIRA data into SQL Server and update Parent IDs column of Story with respective Epic ID and Parent ID column of Task with Story ID and then define hierarchy. Just to achieve, I need to write an ETL code and use a Database.

- Or Is there any other way. Please advice.

Thanks,

Danish

[Vidyabhingamire]

Hi Lydia,

Could you please help with the same prodblem. I would like to create hirechial relationship between Epic and rest of the elements.

If I click on Epic  then it should give me all the task,stories and sutasks under that Epic.

Thanks,

Vidya

[v-yuezhe-msft]

@danishs，

Based on my test, drill down feature is not available for Task in Gantt chart, we are only able to drag one field to the Task section of the chart.

However, if you still have questions about creating hierarchy for your fields in Power BI Desktop, please share sample data of your table and post expected result here.

Regards,
Lydia