To group the nodes in swim lanes, we need to provide the grouping information.
Consider the below example where we have one group and three nodes in it:
Image 1: Sample group view inspired by Process Flows
We will need additional rows for every group that we create. The last column in the above snapshot is the identifier row for the group
In addition to the Id, Pid and other entity attributes required for the basic view, we need the following columns for grouping/swim lane view:
Data Column
Mandatory/Optional
Description
Group Id
Mandatory
Id of the Group in the group identifier row
Subtree Id
Mandatory
Specifies the ID of the Group in which the node resides
Group color
Optional
Color coding of the Group background
The data structure required for the above group view is as follows:
Image 2: Data required for the view in Image 1
Manually transforming group information in the required structure can be time-consuming. Instead, you can easily use a few transformation steps in Power Query to create the required data structure.
Resources for Grouping/Swimlane View
These resources will assist you transform your current data structure dynamically to fit the required format for the grouping/swimlane view:
