Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi,
First time poster, long time reader, so apologies if I miss something in my description.
Summary:
I want to create a unique web link in a column that contains values from other columns and the user's username for a 3rd party system, but am struggling to use the username() function as the link in each row as it can't be used in a calculated column.
Detail:
I have an application that reads data from a SQL Server DB. If the data is in a certain state, I want to create a link to our JIRA system to populate a Create Ticket page with all the relevant details. All good, except that I need to change the username in the URL to be that of the current user in Power BI.
Example table (SimulatedMainTable):
Parameter1 | Parameter2 | Parameter3 | JIRALink | UserNameMeasure |
a | b | c | http://jira.mysite.com/CreateTicket?param1=a¶m2=b&username=myusername | uk003119@site.com |
d | e | f | http://jira.mysite.com/CreateTicket?param1=d¶m2=e&username=myusername | uk003119@site.com |
Solved! Go to Solution.
Hi @pcardno
You can create a Masure like.
SELECTEDVALUE( table[hlColumn] ) & USERPRINCIPALNAME()
Hi @pcardno
You can create a Masure like.
SELECTEDVALUE( table[hlColumn] ) & USERPRINCIPALNAME()
Hi @Mariusz ,
That worked, thank you. Unfortunately, it looks like the performance of the function call when applied across a few thousand rows isn't going to work (it just hangs on more than a couple of rows in the table) but your solution did what I was asking for.
Thanks again,
Paul.
User | Count |
---|---|
127 | |
72 | |
70 | |
58 | |
53 |
User | Count |
---|---|
192 | |
96 | |
67 | |
64 | |
54 |