To add a hyperlink in Power BI, you can follow these steps:
- Open Power BI and go to the report or dashboard where you want to add the hyperlink.
- Select the visual element (e.g., text box, shape) that you want to turn into a hyperlink.
- In the “Visualizations” pane, click on the “Format” button (paint roller icon) to open the formatting options for that visual element.
- Under the “General” section, enable the “Web URL” option.
- Enter the desired hyperlink URL in the “Web URL” field. You can also use dynamic measures or fields by referencing them within square brackets like [MeasureName] or [FieldName].
- Adjust other formatting properties (e.g., font, background color) if necessary.
- Save the changes, and the visual element will now behave as a hyperlink when clicked.
Here’s an example of adding a hyperlink to a text box in Power BI using the above steps:
- Open Power BI and create a new report or open an existing one.
- Insert a text box by clicking on the “Text box” option in the “Home” tab.
- Type in the desired text for the hyperlink (e.g., “Click here for more information”).
- Select the text box, and in the “Visualizations” pane, click on the “Format” button.
- Under the “General” section, enable the “Web URL” option.
- Enter the URL of the website or the link you want to redirect to when the text box is clicked.
- Customize the formatting properties of the text box if needed.
- Save the changes, and the text box will now act as a hyperlink to the specified URL.
That’s it! You have successfully added a hyperlink in Power BI. Enjoy using interactivity in your reports and dashboards!