Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi all
I want to link certain numbers to a hyperlink but show the number and not the hyperlink. is this possible using the concatenate DAX code?
Sorry I have had to redact due to security reasons.
But basically I have put the internal site followed by the column with the number but it shows the full site address along with the number on the end. I just want it to show the number not the full link.
Hope this makes sense
James
Solved! Go to Solution.
@JamesMurg You can use number column and then use conditional formatting. In conditional formatting, use Web URL and then select the full URL. By using this, you will be able to show only number as link. See below screen shot. Hope this helps you.
@JamesMurg , You can create a new column or measure and use that as per need.
new column = "https//abc.com?item_id=" & [Item Id]
@JamesMurg You can use number column and then use conditional formatting. In conditional formatting, use Web URL and then select the full URL. By using this, you will be able to show only number as link. See below screen shot. Hope this helps you.
User | Count |
---|---|
107 | |
88 | |
81 | |
76 | |
71 |
User | Count |
---|---|
112 | |
105 | |
96 | |
74 | |
66 |