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 (slicers).
I have something like this:
TargetURL = Concatenate("https://www.google.com/",FirstNonBlank(d_Categories[Category],1))
Please help!!
10 Replies
Unfortunately you cannot change data category for a measure, here is an idea, vote for it.
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!
but it will not be a clickable hyperlink in the report if that is an requirement.
Yes, I need it to be a Hyperlink.
