# Issue Key with Hyperlink? **URL:** \ **Category:** Questions & Answers\ **Tags:** jira\ **Created:** [January 8, 2024, 12:44pm UTC](https://community.eazybi.com/t/issue-key-with-hyperlink/14692 "2024-01-08T12:44:46Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![Esteban\_Halabi](https://community.eazybi.com/user_avatar/community.eazybi.com/esteban_halabi/32/10092_2.png) [@Esteban\_Halabi](https://community.eazybi.com/u/Esteban_Halabi)\ **Post date:** [January 8, 2024, 12:44pm UTC](https://community.eazybi.com/t/issue-key-with-hyperlink/14692/1 "2024-01-08T12:44:46Z")
Hello everyone! I’m trying to create a measure that pulls the “issue key” but makes it a clickable link. is that possible? I’ve seen it done with “linked issues” where I actually get hyperlinks to the linked issues. Thank you for the assist! ---
**Author:** ![Marita\_Burgio](https://community.eazybi.com/user_avatar/community.eazybi.com/marita_burgio/32/11216_2.png) [@Marita\_Burgio](https://community.eazybi.com/u/Marita_Burgio)\ **Post date:** [January 12, 2024, 3:16pm UTC](https://community.eazybi.com/t/issue-key-with-hyperlink/14692/2 "2024-01-12T15:16:23Z")
Hello @Esteban_Halabi, Thanks for your question! You can create the following calculated measure to get the hyperlink for the Issue key: ```auto CASE WHEN [Issue].CurrentMember.level.name = "Issue" THEN "[*" ||Cast([Issue].CurrentMember.Key as string) ||"*]" ||"(https://eazybi-training.atlassian.net/browse/" ||Cast([Issue].CurrentMember.Key as string) ||")" END ``` Please make sure that you have selected “Markdown” as Formatting. ![image.png](https://community.eazybi.com/uploads/default/original/2X/7/7727854f233ec8622aa390a80e9eca93a74e2e6c.png) An example of this is available on our Demo account here: [List of issues in progress - Issues - Jira Demo - eazyBI](https://eazybi.com/accounts/1000/cubes/Issues/reports/281703-list-of-issues-in-progress) ![image.png](https://community.eazybi.com/uploads/default/original/2X/0/03ea33207da4ad3815e1e4696b035cd7d604d451.png) You can also left-click on the Issue name you have on Rows and select “Go to Source” to access the Issue. I hope this helps! Best, Marita // [support@eazybi.com](mailto:support@eazybi.com) ---
**Author:** ![Esteban\_Halabi](https://community.eazybi.com/user_avatar/community.eazybi.com/esteban_halabi/32/10092_2.png) [@Esteban\_Halabi](https://community.eazybi.com/u/Esteban_Halabi)\ **Post date:** [January 24, 2024, 7:21pm UTC](https://community.eazybi.com/t/issue-key-with-hyperlink/14692/3 "2024-01-24T19:21:03Z")
You’re amazing! thank you, I’ll be trying this! Appreciate the help ---
**Author:** ![Esteban\_Halabi](https://community.eazybi.com/user_avatar/community.eazybi.com/esteban_halabi/32/10092_2.png) [@Esteban\_Halabi](https://community.eazybi.com/u/Esteban_Halabi)\ **Post date:** [March 6, 2024, 11:04pm UTC](https://community.eazybi.com/t/issue-key-with-hyperlink/14692/4 "2024-03-06T23:04:31Z")
Hi Marita! I have one more question about this. I was able to make it work when my “Issues” dimension is set to “all issues”, however if I select “all issues by epic” which I need in some reports it no longer displays the issue key at all (so no hyperlink) any clue what could be causing that? Thank you! ---
**Author:** ![Marita\_Burgio](https://community.eazybi.com/user_avatar/community.eazybi.com/marita_burgio/32/11216_2.png) [@Marita\_Burgio](https://community.eazybi.com/u/Marita_Burgio)\ **Post date:** [March 7, 2024, 3:12pm UTC](https://community.eazybi.com/t/issue-key-with-hyperlink/14692/5 "2024-03-07T15:12:35Z")
Hi @Esteban_Halabi, The reason you no longer see hyperlink or the Issue key is because the calculated measure you created works on the Issue level. If you wish to see the results for your Epics, you just need to adjust the formula to the following: ```auto CASE WHEN [Issue].CurrentHierarchyMember.level.Name = "Epic" THEN "[*" ||Cast([Issue].CurrentHierarchyMember.Key as string) ||"*]" ||"(https://eazybi-training.atlassian.net/browse/" ||Cast([Issue].CurrentHierarchyMember.Key as string) ||")" END ``` You can also use the one below if you need to switch between two hierarchies in the same report. This formula below will show you the Key and Hyperlink for Epics when you are choosing the “Epic” hierarchy and “Issues” when in the Issue hierarchy: ```auto CASE WHEN [Issue].CurrentHierarchyMember.level.Name = "Epic" OR [Issue].CurrentHierarchyMember.level.Name = "Issue" THEN "[*" ||Cast([Issue].CurrentHierarchyMember.Key as string) ||"*]" ||"(https://eazybi-training.atlassian.net/browse/" ||Cast([Issue].CurrentHierarchyMember.Key as string) ||")" END ``` Please make sure that you have selected “Markdown” as Formatting. Best, Marita // [support@eazybi.com](mailto:support@eazybi.com) ---
**Author:** ![Esteban\_Halabi](https://community.eazybi.com/user_avatar/community.eazybi.com/esteban_halabi/32/10092_2.png) [@Esteban\_Halabi](https://community.eazybi.com/u/Esteban_Halabi)\ **Post date:** [March 7, 2024, 5:42pm UTC](https://community.eazybi.com/t/issue-key-with-hyperlink/14692/6 "2024-03-07T17:42:51Z")
Hello! thank you for getting back to me! totally understand what’s going on now, however when I try to use the formulas you gave me now I get this error ![image](https://community.eazybi.com/uploads/default/original/2X/1/1ea419dbac5d22a951c8f3c27fc16a9620d2e18d.png) ---
**Author:** ![Marita\_Burgio](https://community.eazybi.com/user_avatar/community.eazybi.com/marita_burgio/32/11216_2.png) [@Marita\_Burgio](https://community.eazybi.com/u/Marita_Burgio)\ **Post date:** [March 12, 2024, 2:42pm UTC](https://community.eazybi.com/t/issue-key-with-hyperlink/14692/7 "2024-03-12T14:42:14Z")
Hi @Esteban_Halabi, Sorry, I made a mistake when pasting the formulas and didn’t notice. I have corrected both of them in the message above (so that other people avoid using the wrong formula). Thanks for the follow-up as it allowed me to catch this mistake. Best, Marita // [support@eazybi.com](mailto:support@eazybi.com) ---
**Author:** ![Esteban\_Halabi](https://community.eazybi.com/user_avatar/community.eazybi.com/esteban_halabi/32/10092_2.png) [@Esteban\_Halabi](https://community.eazybi.com/u/Esteban_Halabi)\ **Post date:** [March 13, 2024, 8:10pm UTC](https://community.eazybi.com/t/issue-key-with-hyperlink/14692/8 "2024-03-13T20:10:24Z")
Hi @Marita_Burgio I appreciate the fix! and the continued support on this. New ask, or question lol. With your new measure I can see the key for the Epics now yes, but ONLY epics, (either option you provided, it only displays epics) ![image](https://community.eazybi.com/uploads/default/original/2X/6/68551e89a53f55c34ebc05c3ff62d5525f3e3b8d.png) ![image](https://community.eazybi.com/uploads/default/original/2X/0/024298861d1c6a44283bc905d46573eb9cfaca54.png) is there a way for it to work for all issuetypes when it’s being displayed by epic? ---
**Author:** ![Marita\_Burgio](https://community.eazybi.com/user_avatar/community.eazybi.com/marita_burgio/32/11216_2.png) [@Marita\_Burgio](https://community.eazybi.com/u/Marita_Burgio)\ **Post date:** [March 14, 2024, 2:43pm UTC](https://community.eazybi.com/t/issue-key-with-hyperlink/14692/9 "2024-03-14T14:43:50Z")
Hi @Esteban_Halabi, No worries, I understand your request better now. The formula I provided earlier showed hyperlinks for Issue and Epic levels in their respective hierarchies. If you would like to see hyperlinks for any level, you can use the formula below: ```auto CASE WHEN [Issue].CurrentHierarchyMember.level.Name <> "Project" AND [Issue].CurrentHierarchyMember.level.Name <> "(All)" THEN "[*" ||Cast([Issue].CurrentHierarchyMember.Key as string) ||"*]" ||"(https://eazybi-training.atlassian.net/browse/" ||Cast([Issue].CurrentHierarchyMember.Key as string) ||")" END ``` This formula excludes hyperlinks being created for “All” and “Project” levels, as they would not make a correct link. Hope this helps! Best, Marita // [support@eazybi.com](mailto:support@eazybi.com) ---
**Author:** ![Esteban\_Halabi](https://community.eazybi.com/user_avatar/community.eazybi.com/esteban_halabi/32/10092_2.png) [@Esteban\_Halabi](https://community.eazybi.com/u/Esteban_Halabi)\ **Post date:** [March 14, 2024, 9:31pm UTC](https://community.eazybi.com/t/issue-key-with-hyperlink/14692/10 "2024-03-14T21:31:57Z")
THANK YOUUUUUU SO MUCH! THIS IS IT! So happy! I really appreciate the help! and I’m sorry If I wasn’t clear enough on my initial request!