Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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.
Hi Eason, thank you so much! Thats perfect 😄
We beginning to think it was impossible.
I owe you one.
Kind regards
Mark
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.