Forum Discussion
Display 'Related Items' as link within PowerBI Report
- 5 years ago
Yes, if you have some table with URL link (or any other values from which you are able construct URL link), you can load to report (and if you want, you can relate to detail data in report).
Then you can add classic Table and add some column (you can use some another value for link label), and in Conditional formating section, select rigth column when you can show, enable Web URL link format, and then select column contains URL link.
- 5 years ago
Hi, Shelley-Baynton
You can try the following steps.
1 Create a Measure (Measure can save your Memory)
format_url =
SWITCH (
SELECTEDVALUE ( items[item] ),
"A", "https://docs.microsoft.com/en-us/dax/switch-function-dax",
"B","https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-conditional-table-formatting"
)
2 Conditional format ‘item’ column
The result looks like this:
When clicking the item, related link will be opened in browser.
Here is the sample.
Best Regards,
Caiyun Zheng
Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, Shelley-Baynton
You can try the following steps.
1 Create a Measure (Measure can save your Memory)
format_url =
SWITCH (
SELECTEDVALUE ( items[item] ),
"A", "https://docs.microsoft.com/en-us/dax/switch-function-dax",
"B","https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-conditional-table-formatting"
)
2 Conditional format ‘item’ column
The result looks like this:
When clicking the item, related link will be opened in browser.
Here is the sample.
Best Regards,
Caiyun Zheng
Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.