Forum Discussion

willbost5's avatar
willbost5
New Member
5 years ago
Solved

Add Hyperlinks to Column Headers in Table or Matrix?

Is there a way to add different hyperlinks to different column headers in a table or Matrix?  As Example:

 

DepartmentMetric 1Metric 2Metric 3
Accounting10%0.05%85%
Marketing12%0.80%91%
Operations18%0.12%71%

 

Would like to link each column header Metric 1, Metric 2 and Metric 3 to distinct URLs for each header.

  • willbost5 I don't think there is a way to add a hyperlink to the column header, only it can be set to the values.

     

    Check my latest blog post Comparing Selected Client With Other Top N Clients | PeryTUS  I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

    Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.

2 Replies

  • willbost5 I don't think there is a way to add a hyperlink to the column header, only it can be set to the values.

     

    Check my latest blog post Comparing Selected Client With Other Top N Clients | PeryTUS  I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

    Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.

  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    Icon for Community Support rankCommunity Support

    Hi , willbost5 ;

    Based on my test , it is unsupported to add Hyperlinks to Column Headers in Table or Matrix in Power BI currently. While your demand is a good idea, you can post your new idea in Idea Forum , add your comments there to improve Power BI and make this feature coming sooner.

     

    As a workaround, you may extract all Column Headers As a column and add the URL. The specific steps are as follows:

    step1:Duplicate table and rename it (Column Headers)

    step2:Input expression in power query

    = Table.ColumnNames(#"Changed Type")

    step3:Add URL column

    step4: add web url

    The final output is shown below:

    You also can refer to the document Add hyperlinks (URLs) to a table.

    Best Regards,
    Community Support Team_ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.