Generate automatically a WEB URL with Filter in it

[Anonymous]

We are using Jira in our Company that is plattform for agile developing, and in Jira we have reports which are done with EasyBI. Now we have decided to do our Reports with PowerBI. I have created a Data Cube which is live connected with Power BI.

What you should now is that there are "Issues" existing in Jira, and every Issue has a key (issue_key). Now one of our Reports in EasyBI ish showing the issue trend over time. and when I click for example on the month July 2019 in the Report i can drilltrough Issues and get a List with all the Issues created and closed in month July. 

And when i click the Open first 100 in Jira issue navigator, it created following link somehow automaticly:

http://emea-issues.dormakaba.com/issues/?jql=key%20in%20(BCOMM-596%2CBCOMM-597%2CBCOMM-598%2CBCOMM-6...

Now my Question is now can i do the same thing in PowerBI ? 

When i choose for example month july that power BI generates somehow a Link with all the issue_keys in month july?

Because now im doing an alternative, I have created a table which shows the link of each issue in jira but i need it to be as the example above.

[mwegener]

Hi @Anonymous ,

did you solve your problem?

If I answered your question, please mark my post as solution, this will also help others.

Please give Kudos for support.

[Anonymous]

@mwegener  solved it differently but that could also work 😄

[mwegener · Accepted solution]

Hi @Anonymous,

try this

PBIX

If I answered your question, please mark my post as solution, this will also help others.

Please give Kudos for support.