Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

undefined

I have a table with data about Jira issues. When I select a row in the table I want to visualize the child items of the selected issue, just to show you what I mean I want something like this: 

So when I select "Name 3" I want the rows to expand and show another table with connected issues inside of the original table, or something similar. Is this possible in some way? I know I can probably just show the table with the child items next to the first one but that's not the best fit for this case.

Need Help

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Ok, I'll just do another table next to the first one then.
    I can't figure out how to get the value of the selected cell or row from the first table, is it possible?

  • v-kkf-msft's avatar
    v-kkf-msft
    Community Support
    4 years ago

    Hi Anonymous ,

     

    I create the sample data.

     

          

     

    Please check if this matches your desired output.

     

    Accountable and Reporter = 
IF (
    ISINSCOPE ( Ticket[Ticket ID] ),
    SELECTEDVALUE ( Ticket[Reporter] ),
    IF ( ISINSCOPE ( 'Table'[Name] ), MAX ( 'Table'[Accountable] ) )
)
    Prio and Title = 
IF (
    ISINSCOPE ( Ticket[Ticket ID] ),
    SELECTEDVALUE ( Ticket[Title] ),
    IF ( ISINSCOPE ( 'Table'[Name] ), SUM ( 'Table'[Prio] ) )
)


    If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
    Best Regards,
    Winniz
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

  • v-kkf-msft's avatar
    v-kkf-msft
    Community Support
    4 years ago

    Hi Anonymous ,

     

    Has your problem been solved? If it is solved, please mark a reply which is helpful to you.

     

    If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.


    Best Regards,
    Winniz