Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Generate automatically a WEB URL with Filter in it

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-606%2CBCERP-762%2CBCERP-927%2CBCERP-984%2CBCERP-995%2CBCERP-1010%2CBCERP-1013%2CBCERP-1014%2CBCERP-1017%2CBCERP-1019%2CBCERP-1022%2CBCERP-1024%2CBCERP-1026%2CBCERP-1027%2CBCERP-1030%2CBCERP-1040%2CCRE-167%2CCRE-721%2CCRE-855%2CCRM-414%2CCRM-902%2CCRM-931%2CCRM-925%2CCRM-973%2CCRM-984%2CCRH-563%2CCRH-564%2CCRR-843%2CCRR-886%2CCRR-891%2CCRR-909%2CCRR-939%2CCRR-963%2CDEFPT-252%2CDEFPT-1161%2CDEFPT-1479%2CDMXSDTA-1322%2CTESTLTAA-1%2CESMW-490%2CESMW-2245%2CESMW-2932%2CESMW-2948%2CESMW-3172%2CESMW-3179%2CESMW-3190%2CESMW-3202%2CESMW-3203%2CESMW-3256%2CESMW-3267%2CESMW-3269%2CESMW-3270%2CESMW-3273%2CESMW-3280%2CESMW-3292%2COAM-9630%2COAM-17332%2COAM-19618%2COAM-21088%2COAM-24976%2COAM-25116%2COAM-27299%2COAM-27465%2COAM-27467%2COAM-27845%2COAM-27882%2COAM-28418%2COAM-28597%2COAM-28675%2COAM-28793%2COAM-28812%2COAM-28919%2COAM-29175%2COAM-29343%2CKEM-1951%2CKEM-2014%2CMTX-45772%2CMTX-46024%2CMTX-46089%2CMTX-46309%2CMTX-46349%2CMTX-46366%2CMTX-46385%2CMTX-46392%2CMTX-46455%2CMTX-46481%2CMTX-46494%2CMTX-46495%2CMTX-46497%2CMTX-46499%2CMTX-46502%2CMTX-46503%2CMTX-46504%2CMTX-46505%2CMTX-46508%2CMTX-46516%2CMTX-46528%2CMTX-46529)

 

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.

  • 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.

3 Replies

  • mwegener's avatar
    mwegener
    Icon for Most Valuable Professional rankMost Valuable Professional

    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.

  • mwegener's avatar
    mwegener
    Icon for Most Valuable Professional rankMost Valuable Professional

    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's avatar
      Anonymous
      Not applicable

      mwegener  solved it differently but that could also work 😄