Forum Discussion

JTK21's avatar
JTK21
New Member
3 years ago

Missing Hyperlink in some rows

Hi everyone,

I have a problem with the output of my hyperlinks. In some cases the hyperlink is not stored. The data comes mainly from two tables. Id, hyperlink from table A and employee from table B. The case where the link does not work is when there is no employee for the id and therefore a NULL value is in it. However, I wonder why it should affect the hyperlink, because it is obviously there and is only composed of a URL + Id.

 

 

Can anyone help me with this?

 

Need Help

6 Replies

  • NikhilChenna's avatar
    NikhilChenna
    Skilled Sharer
    3 years ago

    Hi JTK21 ,

     

    Can you share some sample data with thr links so that we can understand more clearly .

     

    Regards,

    Nikhil Chenna

  • JTK21's avatar
    JTK21
    New Member
    3 years ago

    Hi NikhilChenna ,

    of course, so here is the definition of my Hyperlink : 

     

    I have added this as a web URL under the "Conditional formatting" field.

    Here is another example:

     

    and the Data Model:

    please let me know if you need more information and if so what kind of Data

    Best Regards,
    J

    • Sweet-T's avatar
      Sweet-T
      Helper III
      2 years ago

      Hey J, did you get closure on this? 

      I'm guessing it had something to do with the fact that the rows without hyperlinks also didn't have Emloyees listed? Maybe because they didn't have rows in the related table, the conditional formatting wouldn't populate? 

      I am also having this issue. 

    • JortB's avatar
      JortB
      Frequent Visitor
      5 months ago

      You could try to set the data category to web url, for the hyperlink column.

  • Higgins's avatar
    Higgins
    Regular Visitor
    2 years ago

    The reason is that one or more of the columns in the table is summarised.  Right click each column in the table visual's Columns well and make sure Don't Summarise is selected.