Add Hyperlink to other Hierarchy in Table Matrix

[Anonymous]

This is the sample table I have.

Campaign ID	Campaign1	Campaign2	Campaign3	Campaign4	Campaign Link
123	Test April 17th	Parent Campaign Test April 17th	Test April 17th v2	May 10th Testing	https://test.crm5.dynamics.com/CRMReports/viewer/drillopen.aspx?ID={123}&LogicalName=campaign
234	Parent Campaign Test April 17th				https://test.crm5.dynamics.com/CRMReports/viewer/drillopen.aspx?ID={234}&LogicalName=campaign
345	Test April 17th v2	Parent Campaign Test April 17th			https://test.crm5.dynamics.com/CRMReports/viewer/drillopen.aspx?ID={345}&LogicalName=campaign
456	May 10th Testing	Parent Campaign Test April 17th	Test April 17th v2		https://test.crm5.dynamics.com/CRMReports/viewer/drillopen.aspx?ID={456}&LogicalName=campaign
567	WBN-2020-05-23 Azure incentive AU 2323	Parent Campaign Test April 17th	Test April 17th v2	May 10th Testing	https://test.crm5.dynamics.com/CRMReports/viewer/drillopen.aspx?ID={567}&LogicalName=campaign

This is the Report

As you can see all the highlighted is the Campaign2, Campaign3 & Campaign4 and does not have a hyperlink.

How can I lookup or have a workaround to add the hyperlink on the Campaign2, Campaign3 & Campaign4?

Any thoughts? Thank you!

[v-cazheng-msft]

Hi, @Anonymous 

I've done test with your sample data. I got a Matrix as following. Is it the result you wanted?

Here is the sample.

Best Regards,

Caiyun Zheng

Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Thanks so much for the response.

As I can see in the Value you used "First Campaign Link" 

I used SELECTEDVALUE(Campaigns[Campaign Link]) to remove the "First" and the hyperlink in the Campaign2, Campaign3 & Campaign4 is gone. Is there a way to have a hyperlink for the other column. The ID for them is like in the Campaign 1.

Thank you.

[v-cazheng-msft · Accepted solution]

Hi, @Anonymous 

You can create a Measure like following and then add it to the Matrix visual.

CampaignLink =

IF (

    HASONEVALUE ( 'sample table'[Campaign Link] ),

    SELECTEDVALUE ( 'sample table'[Campaign Link] ),

    MAX ( 'sample table'[Campaign Link] )

)

The result looks like this:

If you want to add hyperlink to another column, you can consider Conditional formatting with Web URL. You may need create a Measure firstly, in this issue, there is a reply may help you.

Best Regards,

Caiyun Zheng

Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Thanks for the response @amitchandak 

I just want to have a single column for all the hyperlink for the Campaign 1,2,3,4.

Is there any workaround we can do for this one?

Thank you so much!

[amitchandak]

@Anonymous , if you have added using conditional formatting web URL, then do it for total and value