Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Showing a visualization with Parent Child/Successor Predecessor relationship

Hi, I wanted suggestions from the community as to which chart should be used to depict the Parent-Child/Successor-Predecessor relationship. I'm using Azure boards as a data source. Here is my sample data source. 

WorkItemIDPredecessor IDSuccessor IDSource ID TitleIteration
1 2Item 11
2  Item 22
3  Item 31
435Item 42
5 6Item 51
6  Item 62

 

I want to show each work item id in the center and its Predecessor on the top left and successor on the bottom right. With that, I want to arrange my items based on iteration.

Here is how I'm trying to visualize my data.

 

 

 

I don't need links to the Microsoft Custom Visuals Page. I know that it exists. I'm expecting somebody to point out to a visual in the market place that could help me with my scenario.

 

 

Show and Tell

5 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      amitchandak  did you even read the question on what I wanted or are you in a competition to become a super user and blindly answer as many questions as possible with irrelevant links?

  • v-kelly-msft's avatar
    v-kelly-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi  Anonymous ,

     

    A workaround for you :

    First create 2 measures as below:

    _Predecessor ID = 
var _predecessor=CALCULATE(MAX('Table'[Predecessor ID]),FILTER(ALL('Table'),'Table'[WorkItemID]=SELECTEDVALUE('Table'[WorkItemID])&&'Table'[Iteration]=SELECTEDVALUE('Table'[Iteration])))
Return
"Pre:"&"  "&_predecessor
    _Successor ID = 
var _successor=CALCULATE(MAX('Table'[Successor ID]),FILTER(ALL('Table'),'Table'[WorkItemID]=SELECTEDVALUE('Table'[WorkItemID])&&'Table'[Iteration]=SELECTEDVALUE('Table'[Iteration])))
Return
"Suc:"&"  "&_successor

    Then select "multi-card" visual,go to format>category labels:off;

    Finally create a measure as below:

    Measure = "Iteration"&SELECTEDVALUE('Table'[Iteration])

    Go to format>title,choose "formatting",and put measure in it.

    And you will see:

    Not a perfect solution,but very close to,hope it can solve your issue.

     

     

    Best Regards,
    Kelly
    Did I answer your question? Mark my post as a solution!

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago
      Hi Kelly, Thanks for your efforts.Appreciate that. However I already have those columns. I just need a way to visualize that data in power bi. I'm looking out for chart options that would best convey this relationship.
      • v-kelly-msft's avatar
        v-kelly-msft
        Icon for Community Support rankCommunity Support
        6 years ago

        Hi @leharkapil ,

         

        Yes I know, creating those columns is to make the card visual be performed closely as you expected.But how to adjust the position and change the color is still a problem,I suggest you post your new idea in Power BI ideas via below link and make this feature coming sooner.
        https://ideas.powerbi.com/forums/265200-power-bi-ideas
        Some comments are very meaningful there.

         


         
        Best Regards,
        Kelly
        Did I answer your question? Mark my post as a solution!