Force-directed nodes

[nlui]

Hello everyone, is there was way to add additional layers in the force-directed nodes visual? For example I'm try to show relationships between various fruits; apples, oranges, melons. Apples have different varieties and colors, same as oranges and melons. My current node will only show a central fruit node to apples, oranges, and melons but won't let me get to the varieties under each. Is there another visualization I could be using instead?

[pxg08680]

@nlui

Below table shows the raw data and right side is Force-directed graph.

 

So the graph shows me all three layers. Is this what you have asked for..?

[nlui]

This a visualization I'm trying to create in PowerBI, right now its in PowerPoint. The data starts off at a high level then continues to get more granular, in this example "Fruit" is the highest level, then it goes further into "Type" (Apples, Melons, Pears) -> "Color" (Green, Red, Brown, Orange, Multi) -> "Varieties" (Anjou, Granny Smith, Bosc). As the data drills down, these are the different "nodes" that I'd like to show.

From there I also want to show the links between each node, in this case by the dark orange bi-directional arrows. Apples and pears are connected by the colors red and green, also apples and melons are connected by the color green. 

[pxg08680]

@nlui

I tried to play around but couldn't find something which can be shown as your PPT diagram.

Does your data has all text type or any numeric fields..?

Hope someone helps you in this.

[nlui]

Thanks for taking a shot at it, my actual data is all text. Maybe the force-directed node visualization isn't the right one? I've searched the library but none of the visuals I looked at had additional layers.

[v-shex-msft]

Hi @nlui,

I'm not so clear for your requirement, can you please share some detail contents?

If you only want to shows single item, you can try to use category column and detail information column to create table visual, and switch the detail column to first/last mode.

Regards,

Xiaoxin Sheng

[nlui]

Hi @v-shex-msft, Is there way for the nodes to expand to lower hierarchical levels? Say the first node is "Fruit" then that has three nodes that connect to it, (1) apples (2) bananas (3) melons. Then from the "apples" node three other nodes connect to it (1) fuji (2) granny smith (3) gala. Same goes for bananas and melons. Right now I can only create a nodes that show a connection to fruit-> gala, or apples->gala.