# KPI Tree The xViz Performance Flow visual offers an advanced KPI Tree, ideal for visualizing interconnected key performance indicators (KPIs) and their relationships. {% embed url="" %} Demo report | KPI Tree in Power BI using xViz Performance Flow {% endembed %} Leveraging the insights provided by [Power BI's new INFO functions](https://powerbi.microsoft.com/en-us/blog/power-bi-october-2024-feature-summary/#post-28196-_Toc179458536), the xViz Performance Flow visual offers a structured view of interconnected KPIs, dynamically updating the view ensures that users receive the most current information in the report. With its capability to update as new KPIs are added, the xViz Performance Flow enables teams to stay informed of changes, supporting more effective analysis and management of key metrics across various performance dimensions.

### Steps to Configure the KPI Tree in the Performance Flow Visual: 1. Create a new table using the `INFO.VIEW.MEASURES()` function to display information about the model's measures. The table should include columns for each measure's ID, name, its formula or expression, and its current status, indicating whether it’s in a valid or error state, as shown in the image below:

2. Create a custom column named **"Links"** using the DAX formula below. This column is used as Links to display the relationships between each KPI, helping to identify dependencies among them. {% hint style="success" %} Learn more about [xViz Performance Flow | Links](https://docs.xviz.com/performance-management/links) {% endhint %} ```dax Links = VAR _name = 'Table'[Name] VAR _parentsID = CONCATENATEX( FILTER( 'Table', SEARCH("[" & _name & "]", 'Table'[Expression], 1, 0) > 0 && 'Table'[Name] <> _name ), 'Table'[ID], "," ) RETURN IF(LEN(_parentsID) > 0, _parentsID, BLANK()) ``` As a result, the new column will be create as shown in the image below which shows the comma-separated list of IDs of KPIs that each KPI depends on, showing relationships and dependencies between KPIs.

3. Create a new custom column named **"Parent ID"** using the DAX formula below. This column will take the first ID value from the **Links** column and will be used as the Parent ID in the visual. The Parent ID determines the position of the KPI in the resultant tree structure. ```dax Parent ID = LEFT( 'Table'[Links], FIND(",", 'Table'[Links] & ",", 1) - 1 ) ``` As a result, a new column will be created, as shown in the image below, which displays the first ID of the KPI from the Links column.

Let's begin with the visualization! 4. Import [xViz Performance Flow](https://appsource.microsoft.com/en-hk/product/power-bi-visuals/xviz.performanceflow-xviz?tab=Overview) from Microsoft AppSource into your report. {% hint style="success" %} If this is your first time working with custom visuals, then here are the steps to [import a custom visual from Microsoft AppSource](https://learn.microsoft.com/en-us/power-bi/developer/visuals/import-visual#import-a-power-bi-visual-directly-from-appsource). {% endhint %} 5. Populate the **ID**, **Parent ID**, **Name**, and **Links** columns in the data fields.

6. Navigate to the **Map Field** option in the top ribbon and map these newly populated columns to the **Map Field**, as shown in the image below:

Image 5: Map newly added column in the Map field

7. Conceal the parent-child connectors to focus on the Links: 1. To improve the appearance of the KPI tree, first navigate to the **Display** option in the top ribbon. Then, in the **Navigation** tab, turn off the expand/collapse button. 2. Navigate to the Connectors Tab and set the connector color to transparent to hide the connectors to achieving cleaner view.

8. Now, all the KPIs will be connected to each other based on their Link IDs.

9. To view the connections of any individual KPI, simply click on ellipsis icon in the top-right corner of the node and select the "Show Linked" option, as shown in the image below:

As a result, it will display the relationships between the selected KPI with the other KPIs, as shown below:

#### Download the sample report file: {% embed url="" %}