Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

not clickable URL

hello, 

I did create a dax measure in order to return a web url in power bi report but the url in not clickble? The measure is like that: url = "https......" &MAX('Table'[ Column]), I get the right items id from my data, but the URL is no clickble.

I,ll be greatful if somebody can help me!

11 Replies

  • Smalfly's avatar
    Smalfly
    Icon for Responsive Resident rankResponsive Resident

    Hi Anonymous ,

     

    did you define your column/measure as a web URL?

    You can check/change that in the data view:

     

  • Anonymous's avatar
    Anonymous
    Not applicable

    Yes Smalfly , I did change the data type, and also I forgot to mention that in my data I don,t have any URL column, I create it by DAX meaure, and these not clickable url that I get are connected to my work items.

    • Smalfly's avatar
      Smalfly
      Icon for Responsive Resident rankResponsive Resident

      And when you say it is not clickable, did you test in Power BI desktop or in a published report?

      I remember that I once had the same issue in Desktop but after publishing, it worked fine.

      • Anonymous's avatar
        Anonymous
        Not applicable

        Smalfly  both and still same problem.

  • Anonymous's avatar
    Anonymous
    Not applicable

    Smalfly maybe the formulate should be smth else? And I notice rigth now sthm else, these not clickble link are not correct 😞 I data is from azure devops and I need to link each Item to responding item /link in azure devops from power bi.

    • Smalfly's avatar
      Smalfly
      Icon for Responsive Resident rankResponsive Resident

      Could be but you mentioned that you get the right ID from your data. Is the resulting URL correct, as in can you copy-paste it and use it in your browser?

       

      You might also want to check this blogpost for an example of a working URL.

      • Anonymous's avatar
        Anonymous
        Not applicable

        Smalfly no And I notice that rigth now, these not clickble link are not correct 😞 fact : my data is from azure devops and I need to link each Item to responding item /link in azure devops from power bi.