Combined bar chart inspired by IBSC comparing actual and target values, their absolute and percentage differences.
You can find a downloadable pbix file with two variants of Deneb chart in the Power BI report below.
This visual consists of three concatenated charts. The chart is not responsive: you need to set the width and height of each sub-chart.
I determined outliers based on the interquartile range for a percentage differences chart and labelled them with double triangles. The interquartile range (IQR) stands for the difference between the third (Q3) and the first quartile (Q1). I assumed that outliers are values less than Q1-1.5*IQR or greater than Q3+1.5*IQR. In this way, the visual remains readable even when the percentages are widely scattered.
Get inpired by Aleksandra’s examples of using this visual!
