Network diagram problem

[SparksWillFly]

I have a table of reference numbers, which I have organised into a hierarchical structure
using index and parent. (I’ve also used PATH function to create a column with the hierarchical path)

Using the Network Navigator visual, which I added to PBI using get more visuals option and searching for ‘network’, I want to display the order with the RefNo field as the text, shown below:

ABC566 >> GG234 >> HH233 >> MM196

My problem is that whilst I can get the path to display visually, see below, I cannot achieve it with the reference number:

I’ve tried several variants of the source and target nodes, but this is the closest I can get.  Has anyone used this or another hierarchical visual that would display this solution? 

Any hepl would be greatly appreciated & thanks for looking

[SparksWillFly]

Hi Eason, thank you so much!  Thats perfect 😄  

We beginning to think it was impossible.  

I owe you one.

Kind regards

Mark

[v-easonf-msft · Accepted solution]

Hi, @SparksWillFly 

You need to add a new calculated column  'Parent RefNo'.

Parent RefNo = 
 CALCULATE(MAX('Table'[RefNo]),FILTER(ALL('Table'),'Table'[Index]=EARLIER('Table'[Parent])))

Then apply it to Network diagram.

Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.