Hyperlink in a multi row matrix how to make that

[VdeJong]

Hi,

It's easy to make a hyperlink in een tabel or matrix with only one row, however, is it possible to have a multi row and with the 2nd row  having the hyperlink.

Can somebody give me a hand or explain to me how to achieve this

[v-pgoloju]

Hi @VdeJong,

Thank you for reaching out to the Microsoft Fabric Forum Community, and special thanks to @FarhanJeelani, @Shahid12523 and @kushanNa  for prompt and helpful responses.

Just following up to see if the Response provided by community members were helpful in addressing the issue. If one of the responses helped resolve your query, please consider marking it as the Accepted Solution. Feel free to reach out if you need any further clarification or assistance.

Best regards,
Prasanna Kumar

[kushanNa]

Hi @VdeJong 

Your requirement is not very clear to me. What do you mean by '2nd row'? Do you mean the second row of a table (Table 1) or the second row of a matrix table property (Table 2)?

[VdeJong]

Like in a Matrix, you can place under each major subject other items and you can drill it down. Something like this. First Country but you open Country and underneath you have states, and under states for example cities

Country / States

USA

New York

California

Folrida

etc

Canada

Quebec

Alberta

etc

[kushanNa]

@VdeJong 

I don't think this is possible, but there are some suggestions in this thread. Have a look and see if they work for you. : https://community.fabric.microsoft.com/t5/Desktop/Hyperlink-on-multiple-row/m-p/4270217 

[Shahid12523]

Put the URL column/measure in Values.

Set Data Category = Web URL.

Apply Conditional formatting → Web URL.

If you only want links on 2nd row, use a measure like:

Show Link =
IF ( ISINSCOPE(Table[DetailField]), SELECTEDVALUE(Table[URL]) )

👉 First row = text, second row = hyperlink.

[VdeJong]

does not work,

do you have a your tube maybe

[VdeJong]

Thanks I will try to implement and will get back if it works correctly

[FarhanJeelani]

Hi @VdeJong ,

In Power BI you can have a hyperlink in a matrix that has multiple rows, but the hyperlink has to come from a column (or measure) that contains a Web URL. You can make it appear only on the second row of each grouping by adding a per-row condition (e.g., rank within the group) and returning a URL only for that row.

I have two ways to achieve this:

Option A – Do it with a calculated column (recommended for clarity)

Add an index/order column so you can rank rows within each group.
Create a calculated column that gives the row number inside each group (e.g., by WeekNo, Location, Trade_to_USED).
Create another calculated column that returns the URL only for the second row in each group; others return BLANK().

Mark the URL column as Web URL and place it in the matrix.
Example (adjust to your real table/column names): Assume table is MyTable with: WeekNo, Location, Trade_to_USED, ID (or another field to build the URL), and IndexForOrder (an index you add to keep a stable order).

Row number inside the group (calculated column) RowNumberWithinGroup = RANKX( FILTER( ALL('MyTable'), 'MyTable'[WeekNo] = EARLIER('MyTable'[WeekNo]) && 'MyTable'[Location] = EARLIER('MyTable'[Location]) && 'MyTable'[Trade_to_USED] = EARLIER('MyTable'[Trade_to_USED]) ), 'MyTable'[IndexForOrder], -- use an existing index or a sorting key , ASC, DENSE )

Hyperlink URL only for the second row HyperlinkURL = IF( 'MyTable'[RowNumberWithinGroup] = 2, "https://yourserver/details?id=" & 'MyTable'[ID], BLANK() )

Configure

Set the Data Category of HyperlinkURL to Web URL (Modeling > Data Category > Web URL).
Put WeekNo, Location, Trade_to_USED in the matrix rows.
Put HyperlinkURL in the Values area (you’ll see clickable links only for the second row per group; other rows will be blank).

Option B – Do the grouping/ordering in Power Query (often simpler to maintain)

In Power Query, group by WeekNo, Location, Trade_to_USED.
Within each group, sort by your preferred order and add an Index starting at 1.
Add a new column that returns the URL only when the per-group index = 2; otherwise null.
Expand back to your table and load.
Mark the URL column as Web URL and use it in the matrix.

Please mark this post as solution if it helps you. Appreciate Kudos.