Forum Discussion
Web Url Conditional Formatting - Unable to Select Field
I can't figure out what is going on. I have a column in my model with a url. I've even created the url as a custom column and a measure but expereince the same issue. The url fields in quesiton ...
Hi all, I realize the original post is over 2 yrs old, but just wanted to let you know I finally solved this today on a whim. The issue has to do with implicit measures not working in your model (like user jpperez mentioned in Aug 2022). The solution is as follows:
- Make sure you have a field in your underlying data table with the complete URL in its own column. Do it in SQL if you have the ability, otherwise do it as a computed column in Power Query. Let's call the new column 'URL_column_name' for purposes of step 2. The values in this new URL field should look something like "https://prefix.domainname.ext/whatever" (without quotes).
- Set up a measure (NOT a calculated column), with something along the lines of ... URLToUse:=SELECTEDVALUE(table_name[URL_column_name])
- In PBID, open the Visualizations pane -> Format visual -> Cell elements -> Series -> [choose whatever column name in your visualization table you'd like to embed a hyperlink] -> Web URL: On -> What field should we base this on? -> [URLToUse] i.e. measure you created in step 2 above.
Hope that helps! Cheers everyone