Hyperlink DAX code

[HenryJS]

Hi all,

I'm trying to create a hyperlink for a report but when inputting the below DAX I receive an error saying the CandidateREf cannot be determined?

1.

Thanks,

Henry

[v-jayw-msft]

Hi @HenryJS ,

You are creating a Measure instead of a Calculated column, please modify the DAX to

FORMAT(SELECTEDVALUE('table name'[column name]))

Or please right-click on the table or any column of the table and select new column to create a Calculated Column.

For more details about Measure and Calculated Column, please refer to the video below.

https://www.youtube.com/watch?v=SVEGfqCTodc.

Best Regards,

Jay

Community Support Team _ Jay Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[HenryJS]

Hi,

The calculated column now works and creates the desired hyperlink.

How do I create a button and link to the hyperlink as per image 2? At the moment it is just displaying image 1.

1.

2.

Thanks,

Henry

[v-jayw-msft · Accepted solution]

Hi @HenryJS ,

Please check the following steps as below.

1# Select the calculated column and turn the Data category to Web URL.

2# Select the visual and select Format -> Values turn the URL icon to On.

For more details please check the document below.

https://docs.microsoft.com/en-us/power-bi/power-bi-hyperlinks-in-tables#display-a-hyperlink-icon-ins....

Best Regards,

Jay

Community Support Team _ Jay Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[az38]

Hi @HenryJS 

you are trying to create measure, not caculated column. measure requires some calculaion. try new column

do not hesitate to give a kudo to useful posts and mark solutions as solution