Forum Discussion
Measure as a Hyperlink Help
Hi, Is there a way to add a dynamic Hyperlink to a report? I am only able to use a calculated column to display a hyperlink. But the calculated column doesn't respond to user interactions (sl...
By nesting a VALUES function in your CONCATENATE you can create a measure that concatenates the URL and a value as determined by a slicer related to the column you place in VALUES.
An example would be:
Target URL = CONCATENATE("https://www.google.com/" ,VALUES(FirstNonBlank(d_Categories[category]))
As the slicer that has the data from FirstNonBlank(d_Categories[category] is used, the second part of the concatenation will change.
Hope this helps!