Free 30-Days trial for xViz visuals here!

Performance Flow: 10 key features of Organization Chart in Power BI

Prachi Mishra
July 25, 2023

Are you looking for a dynamic organizational chart in Power BI? xViz Performance Flow provides an interactive and insightful visualization for hierarchical views of many different use-cases like Process Flows and Organization Trees, Cost Center Analysts and Sales Analysts, among many others.

In this blog, we focus only on organizational charts (org charts) and will take a deep dive into the 10 best features of xViz Performance Flow to visualize an Organization Chart in Power BI.

Consider this example – Lucy is the Data Analyst of Contoso Inc. She has been given the requirements below to develop a report for the management. The management of Contoso Inc. needs the following information available in a Power BI report for employee performance tracking:

  • Easy navigation in the chart as the organization contains multiple departments. Users may want to look closer at the trends of the performance.
  • Ability to search for any particular employee in the hierarchy
  • Know the team size of a team leader
  • Visualize any temporary reporting structure changes and cross-team project collaborations
  • The total salary of employees in Contoso is dependent on the performance bonus. Management wants to see the current salary of the employee and the variance from the previous year
  • The trend of the performance scores over the last few assessments
  • Identify low performers
  • Quick view of the QA and Tech team hierarchies
  • Access to additional notes about any employee to easily identify the underlying reasons for the performance trends or salary structures

Let us see how xViz Performance Flow can help Lucy accomplish these goals in Power BI:

1. Navigation

Navigation - Performance flow
Figure 1: Navigation experience in xViz Performance Flow

The visual provides an easy navigation experience with Zooming controls (or mouse wheel) and dragging navigation. The Minimap view provides a reference with respect to the full hierarchy. This will enable the management of Contoso to take a closer look at the employee cards.

2. Search

Search - Performance flow
Figure 2: Search in xViz Performance Flow

The Search feature in the Performance Flow visual provides an effective mechanism to locate the required employee. This will save the management’s time in browsing the complete hierarchy to find a particular employee.

3. Child node count

Child Node Count - Performance flow
Figure 3: Team size as Child Node Count

With a simple toggle button, Lucy can enable the team count on employee cards so she can immediately see how many employees report to that person. The count will be visible when the subtree of the team lead is collapsed, thereby giving the count of employee cards collapsed in the view.

4. Links

Links - Performance flow
Figure 4: Links depicting additional dependencies

In addition to the reporting structure, the Performance Flow visual provides a provision to plot additional dependencies in the form of Links. Lucy can plot different kinds of dependencies. Different kinds of links can be represented using different line styles and colors. This way management has access to all kinds of dependencies like project collaboration, temporary reporting, etc. integrated into the organization tree.

5. KPI & Variance

KPI-Variance - Performance flow
Figure 5: Salary and Variance from the Previous Year

Lucy can display the Current Salary on every employee card. And by also providing the previous year’s salary, the visual will calculate the variance and display it on the employee card.

6. Trend analysis using Sparklines

Figure 6: Trend analysis using Sparklines

Lucy can provide the Monthly Performance Scores trends for the year. The trend line will clearly indicate the performance trend of the employees. Lucy can also add any other KPIs to highlight that KPI’s trend.

7. Alerting

Alerting - Performance flow
Figure 7: Alerting using Conditional Formatting

Lucy can set data-driven rules to identify the low performers. Using conditional formatting of Performance Flow, the cards for the low-performing employees can be highlighted. In the snapshot above, the low performers are highlighted using a red border.

8. Subtree as Tabs

Subtree - Performance flow
Figure 8: “Set as Top Level” button to visualize subtree

Using the “Set As Root Node” option Lucy can create predefined tabs for the QA and Tech team. She will need to set the team leads as the root nodes to focus on their subtrees.

For instance, as Lexie is the QA lead and the entire QA team is represented as her subtree, Lexie can be set as the root node to focus on the QA subtree.

Subtree-tabs - Performance flow
Figure 9: Tabs for quick navigation to specific teams

9. Notes

Notes - Performance flow
Figure 10: Textual notes for employee details

Juan has shown a considerable dip in his performance lately, which would normally require a formal performance review However, with the Notes feature, the management has additional information on employees and they can immediately see that the underlying reason for his performance is health issues.

10. 10+ Predefined Templates

Lucy can choose from 10+ predefined templates for different node designs to suit her report.

Templates - Performance flow
Figure 11: Predefined node card styles

The visual also provides a bunch of formatting options for Lucy to further customize the look and feel of the cards.

In this way, Lucy has been able to accomplish all of the requirements of her management team to visualize the organization hierarchy in an interactive tree structure with additional dependencies. For every employee, they have an integrated view of performance trends, KPIs, and notes to complete the storytelling experience.

In this blog we focused on org charts, but remember that the xViz Performance Flow visual is useful for many different scenarios like Org Chart, Process Flow, Cost Center Analysis, Sales Performance Analysis, etc.

Use-cases - Performance flow
Figure 12: xViz Performance Flow - Example use cases

Try out the xViz Performance Flow visual from Microsoft AppSource. For more details on the features and configurations, please refer to our docs here.

About xViz!
xViz is a leading provider of advanced enterprise-grade visuals for Microsoft Power BI. The powerful, intuitive, and customizable data visualization experience of xViz, maximizes the potential of the data and elevates analysis to new heights. This product is developed by Lumel Technologies (formerly Visual BI), which has a decade of experience in building add-on solutions on top of BI platforms (SAP BI and Power BI) with our suite of innovative products such as ValQ, xViz, and BI Hub.
PBI Certified


5920 Windhaven Pkwy, #130
Plano TX 75093

cross linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram