Forum Discussion
adithyananduri
8 years agoRegular Visitor
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...
ruecj5
8 years agoAdvocate I
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!
- parry2k8 years agoSuper User
but it will not be a clickable hyperlink in the report if that is an requirement.
- adithyananduri8 years agoRegular Visitor
Yes, I need it to be a Hyperlink.
- parry2k8 years agoSuper User
adithyananduri as mentioned before, unfortunately you cannot, give vote to the idea which i sent previously