Power BI – Visualisation – Org Chart

Spent some time experimenting with the excellent “Synoptic Panel by OKViz” custom visualisation and came up with the idea of finding a different way to visualise the costs associated with a companies organisation structure.

Organisation Chart & Associated Salaries and Costs Report

Organisation Chart 01
 Image 1: Report showing Total Salaries and Costs for a fictitious organisation.  The Organisation Chart diagram in the center is an SVG file that has been added to the report using the “Synoptic Panel by OKViz” custom visual.

Click HERE to open up the interactive reports in a new tab.


Organisation Chart 02
Image 2:  The Organisation Chart that has been added to the report using the “Synoptic Panel by OKViz” custom visual.  The chart is linked to a structured table that contains descriptions of the roles and the associated salary and costs.  The colours indicate in which range/state the salary sits.


2017-04-01_161221
Image 3:  The table that is linked to the various visualisations in the report.


Organisation Chart 4
Image 4:  A “Stacked Column Chart” showing the Associate Salary Total by Department and Sub-Departments.


Organisation Chart 5
Image 5:  A “Pie Chart” showing the Associate Salary Total by Department.


Organisation Chart 6
Image 6:  A “Treemap” showing the Associate Salary Total by Department.


Organisation Chart 7
Image 7:  A “Matrix Table” showing the table of Associates Data with Totals.


Organisation Chart 2
Image 8:  A “Table” showing the table of Associates Data.


Organisation Chart 09
 Image 9:  Report showing Total Salaries and Costs for a fictitious organisation.  All the visualisations are filtered by the selections in the “Hierarchy Slicer”.


Organisation Chart 10
 Image 10:  The Organisation Chart reflecting the filtering by the selections in the “Hierarchy Slicer”


Organisation Chart 11
 Image 11:  The Organisation Chart that has been created using Microsoft Visio Pro that is exported as a “.png” file which can then be uploaded to the “SYNOPTIC DESIGNER FOR POWER BI” at the web address, http://synoptic.design/.


Organisation Chart 11
 Image 12:  The Organisation Chart that has been uploaded to the “SYNOPTIC DESIGNER FOR POWER BI” at the web address, http://synoptic.design/ before being exported as a “.svg” for use in the “Synoptic Panel by OKViz” custom visual.


Here’s hoping that this was of interest.  If you have any questions feel free to contact me at fred.williams@insightfuldatasolutions.com

Leave a Reply

Your email address will not be published. Required fields are marked *