How do I pull information about linked issues while also displaying the field data for the dependent

[John_Sellars]

Hello Community,

I am brand new to Power BI. I have familarity with EazyBI but that just makes me lost for now in PowerBI.

I am hoping the question I have has already been solved because is it is basic need when visualizing dependencies in JIRA.

In Power BI I have imported data via a Power BI connector in Jira into PowerBI desktop.

I have pulled in data about a set of 53 Jira Features.

I want to create a matrix in Power BI that I can filter using slicers.

The matrix has the 53 Features on the Left Column. Under the features are the issues linked to that feature.  These are not Epic Links these are other Features linked with a "Relates to" or "Dependency" link type.

So far so good.

The breakdown I have is I would like to display the attributes of the linked issues in the table.  Again I am familiar with doing that in EazyBI but it is not intuitive in Power PI how I create the Measures to retrieve the Linked issue attributes.

I circled in yellow the issues linked to Jira Feature GR-315.   These are not Epic Links.  Some of the issues in the list are other Features and some are Jira Stoires.  That is how I know I am not correctly pulling the data for the linked issues; I am only pulling the data for the Jira Feature that has Dependencies on the list of issues.

Again a table of Dependencies showing which Featuire has a Dependency and what those dependencies are including the owning team, status, and due date is pretty basic need for Agile and therefore I would imagine the Power BI team has this sorted out.

At the end I would like to have a table report that has a set of columns on the left with information about the Feature that has depedencies (due date, status, assignee, etc) and then a set of columns on the right that shows the same type of information for the dependency tickets being worked.

Any information or guidance you can provide is greatly appreciated.

BTW this is a screen shot of the Spreadshheet we want to recreate

[Anonymous]

Were you able to solve this issue? I have the same problem, I would like to see an issue, with its linked issues, and information (like summary, due date ect. for both). How did you relate the tables properly? 

@John_Sellars 

[John_Sellars]

Hi @danextian I am using PowerBI for data analysis of JIRA data.

Jira is a work tracking data base. In that Data base you can have multiple called issuetypes. The issuetypes all have fields of attributes like due date, status, assignee, etc. 

the entities can have a relationship with each other by creating a "link"!between them. There can be multiple links and they are all captured in a field called issue links see the attached image.

In the image with the yellow highlight you see issue GR-315 expanded to show it has 7 issue links.

to answer your question the data values in the matrix are not expected to be repeated ; they are repeated because the field issuelinks in this matrix is referencing the "issue" and not the issue named in the issuelink. That is the problem I need help solving in powerbi.

how do I pull the fields for the Issue and the fields for the issues it is issue linked to?

I am pretty sure I need to have two tables:

1. A table of the issues of interest like GR-315

2. A table of issues that are linked to the issues in the first table

Both tables would have the issues from the first table as the keyID then I would be able to create a 3rd table with everything in it.

this seems like a lot of work, I am expecting powerBI to be able to do it dynamically.

That is, when the row is one of the issuelinks how do I direct PowerBI to refernce the issuelink to pull the values and not the original issue?

please advise and thanks!

[danextian]

Hi @John_Sellars ,

Using a matrix in Power BI is like  using a pivot table in Excel. Anything you put in values tile is aggregated (min, max, earliest, latest, first, last, sum, count,etc) so if you put a dimension in it, it will be summarized one way or another - and will show the crosssection  of the dimensions added to the row and column tiles - eg, the sum of values which month is February and category is "ABC" or the of the first or last salesperson name (in alphabetical order) for the same crosssection.

Now, going back to your matrix, the results are repeating? Is that how it is supposed to be or does the table of the  field in the values tile have a relationship to the fields in the row and column tiles? If they are from the same table, relationship shouldn't matter.