topic Re: How to make hyperlink to every cell in one of column in Direct Query in DAX Commands and Tips

How to make hyperlink to every cell in one of column in Direct Query

Anonymous — Fri, 17 Feb 2023 15:02:49 GMT

Hello Team,

I want to make hyperlink to one of column in Power Bi. The query is direct query. Is there any specific process that I can follow to get this done.

Thanks for your wonderful suggestions.

Re: How to make hyperlink to every cell in one of column in Direct Query

PiEye — Sat, 18 Feb 2023 16:29:20 GMT

Hi Anonymous

Can you articulate further what you are trying to do?

Are you trying to add a URL to a column of a table?

Re: How to make hyperlink to every cell in one of column in Direct Query

Anonymous — Mon, 20 Feb 2023 01:31:35 GMT

PiEye

Consider there are 5 columns in my report. My whole query is live so data gets updated sec by sec. I have to make hyperlink to one of my column. So, if I click on the Title column for one of Row then it should redirect and open that result. I don't want to add additional column with URL.

Re: How to make hyperlink to every cell in one of column in Direct Query

PiEye — Tue, 21 Feb 2023 15:47:20 GMT

What would this hyperlink lead to? What do you mean by leading to the column - is that some sort of information page?

Re: How to make hyperlink to every cell in one of column in Direct Query

Anonymous — Wed, 22 Feb 2023 02:46:52 GMT

PiEye

Thank you for your responses. However, I got workaround from one of my team member. Issue is resolved.

Re: How to make hyperlink to every cell in one of column in Direct Query

AnaaaaZ — Mon, 18 Mar 2024 14:38:36 GMT

Hello, Would you mind sharing your workaround? I am in same situation with you to add hyperlink to a direct query data.

Re: How to make hyperlink to every cell in one of column in Direct Query

Anonymous — Mon, 18 Mar 2024 15:06:48 GMT

Hello,

Please refer below Uvideo

Creating Custom URL and Formatting it o Matrix Table in Power BI || Mandataa (youtube.com)