Adding hyperlinks to your visuals can significantly enhance the interactivity and functionality of your reports. By linking data to external resources or other report pages, you provide users with additional context and actionable insights. This guide walks you through the process of implementing hyperlinks in Zebra BI Tables, from preparing your data to adding them to the visual.
Preparing the data
Let’s kick this off by adding a new table to your report where you’ll define which hyperlinks will be assigned to which attribute. If hyperlinks are already placed within your dimensions table or anywhere else, you can skip this step.
You can establish a connection between an existing table in your data source to create a new table, or you can manually insert data using the Enter data option.

When you import a table, you need to create a relationship between a newly created table and the dimension table related to it. Create a many-to-many relationship with a single direction toward the URL table.

Formatting
The next step is formatting the URL/hyperlink column as a Web URL. Go to the Table view, select the column containing hyperlinks, and change the Data category from Uncategorized to Web URL

Inserting the hyperlinks to the visual
Now, you’re ready to add the hyperlinks to the Zebra BI Tables. Navigate to the Report view and select Zebra BI Tables from the list of visuals in the Visualizations pane. Add a category and measures to the visual, and then take the hyperlink field and place it in the second place under the Values placeholder.


Set summarization to “First” when you add the hyperlink field.

And that’s it; now a hyperlink will highlight on hover, and by clicking on the link, it will take you to the desired location:


The column can be resized or moved from its original position to any other place in the visual (except the first column).

If you want the column to stand out and be more noticeable in the visual, you can change its formatting by applying different background colors, changing the font color, or putting it in bold.

Setting up hyperlinks for hierarchical tables
For hierarchies, the field needs to be defined where it should appear, and it’s best to create a measure where you can easily determine which level the hyperlinks refer to. In the example below, we have a hierarchy with two levels. The first level is the one the hyperlinks refer to, and we don’t want them to repeat on the second level. You can set up the measure as follows:
URL measure =
VAR lvl1 =
ISINSCOPE ( Products[Product Category] )
VAR lvl2 =
ISINSCOPE ( Products[Product Group] )
RETURN
SWITCH ( TRUE (),
lvl2, BLANK (),
lvl1, MIN ( URLs[URL] ) )
This measure includes the ISINSOPE function, which returns the value when the specified column is the level in a hierarchy of levels. With the help of the SWITCH statement, you can build the returning value of each level, starting with the lowest level first. The outcome is demonstrated below: when we expand the hierarchy, the subordinate rows don’t return any values.

Conclusion
Incorporating hyperlinks into your Power BI reports can greatly enhance their usability and give users direct access to additional data or resources. Following these steps, you can easily add hyperlinks to Zebra BI Tables, ensuring seamless interactivity and clearer insights. Whether working with basic tables or hierarchical structures, hyperlinks help you create dynamic reports that empower end users to explore data more effectively.