KPI Tree

The xViz Performance Flow visual offers an advanced KPI Tree, ideal for visualizing interconnected key performance indicators (KPIs) and their relationships.

xViz Performance Flow - KPI TreexViz

Demo report | KPI Tree in Power BI using xViz Performance Flow

Leveraging the insights provided by Power BI's new INFO functions, 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.

GIF 1: KPI Tree

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:

Image 1: INFO.VIEW.MEASURES()

1. 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.

Learn more about xViz Performance Flow | Links

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.

Image 2: Links column

1. 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.

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.

Image 3: Parent ID column

Let's begin with the visualization!

1. Import xViz Performance Flow from Microsoft AppSource into your report.

If this is your first time working with custom visuals, then here are the steps to import a custom visual from Microsoft AppSource.

1. Populate the ID, Parent ID, Name, and Links columns in the data fields.

Image 4: Populate Data columns

1. 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

1. 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.

Image 6: Expand Collapse button

Image 7: Hide connectors

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

Image 8: KPIs connected with Links

1. 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:

Image 9: Show Linked

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

GIF 2: KPI Tree

Download the sample report file:

xViz Performance Flow - KPI TreexViz