Forum Discussion

HenryJS's avatar
HenryJS
Post Prodigy
6 years ago
Solved

Hyperlink DAX code

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
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

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's avatar
    HenryJS
    Post Prodigy
    6 years ago

    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

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      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-instead-of-a-url.

       

      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.