Forum Discussion

RFederer's avatar
RFederer
Frequent Visitor
1 year ago

Link referral

I'm creating a report and I'm having a challenge.

I have built a table with data relating to different customers and I would like that, once you click on a row related to a customer, it would automatically open a web page with the customer's website without having to insert a calculated column.

Need Help
Show and Tell
Tips and Tricks

2 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    1 year ago

    RFederer Should be able to create a measure that does this, something like:

     

    Measure = 
  VAR __Customer = MAX( 'Table'[Customer] )
  VAR __Return = 
    SWITCH( TRUE(),
      __Customer = "Microsoft", "https://www.microsoft.com",
      __Customer = "Google", "https://www.google.com",
      __Customer = "Amazon", "https://www.amazon.com"
    )
RETURN
  __Return

     

    Should be able to categorize this as a URL and add it to the visual. And you also should be able to turn this into a link icon versus displaying the full text.

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi All,
    Firstly  Greg_Deckler thank you for your solution!
    And RFederer ,As only Dax no way to directly realize this demand, we also need some other components to help us complete, we can choose a button, and then open the button's action Select to web url and then enter our dax formula, in our choice of each user, click on the button can be realized after the jump, do not need you to add a new calculation column!

    Selected Customer URL = 
SELECTEDVALUE(Extended_Customer_Data[Customer Website])

     

    I hope my solution has helped you, if you have any further questions you can always contact me and I will get back to you as soon as I receive the message!
    Looking forward to your reply!

    Hope it helps!

     

    Best regards,
    Community Support Team_ Tom Shen

     

    If this post helps then please consider Accept it as the solution to help the other members find it more quickly.