Creating a chart that lists issues in respective cells, separated by commas, and hyperlinked

[crbrown34]

I am working on a chart that has RO’s as rows and Buckets as columns, then VCN ID’s listed in their respective cells, separated by commas, and each VCN ID hyperlinked. I just cannot get them hyperlinked, I was able to display the link but it’s like EazyBI will not read the links correctly, wondering if this is because EazyBI will not register multiple links in the same cell?

I am using the code below for my calculated member and have it formatted as a Markdown, but no luck whatsoever getting each listed issue hyperlinked. Please help!!!

Generate(
Filter(
Descendants([VCN ID].CurrentMember, [VCN ID].[VCN ID]),
[Measures].[Issues created] > 0
),
[VCN ID].CurrentMember.Name || ‘: (https://iss-www.jsc.nasa.gov/ASDB/browse/RVSHTVX-’ ||
REPLACE(CAST(CInt([VCN ID].CurrentMember.Name) + 2061 AS STRING), “.0”, “”) || ‘)’,
', ’
)

[gerda.grantina]

Hi @crbrown34 ,
Try applying markdown formatting to your measure; it should automatically identify the URL links as hyperlinks:

Also, see this demo report where measure “Issue hyperlink” holds hyperlink values: List of issues in progress - Issues - Jira Demo - eazyBI

best,
Gerda // support@eazybi.com

[crbrown34]

Got it working by putting the VCN ID measure into rows instead of in pages. Now is it possible to color code each of these as well? Preferably some kind of highlighted color behind each issue.