02-22-2016 15:59 PM - last edited 08-09-2016 16:20 PM
This is a business driver chart that allows business users to understand what is driving the top line sales results. It is both intuitive and descriptive in the way it communicates the hierarchical drivers of the top line business result (ie what controllable business metrics are driving the total sales result).
The visualisation of the hierarchy allows the business user to spot opportunities in the underlying business metrics that are impacting the result (or results that are being hidden by a different business driver working in the opposite direction).
This report works best on real business data but has been reproduced here using a modified copy of the Contoso Database. The user selects a Year from the slicer and can then drill into the data by Category and/or customer occupation.
Learn more about this report from the author by watching this video: https://youtu.be/b1I1CucA1Rc
I'll be honest - the design and layout of this are really clever and unique - very cool! However, the execution of it could be improved upon. The text box KPIs and trendlines don't always fit well. But still, very cool idea.
The "custom slicers" you mention are Chiclet Slicer (custom visual).
Matt wrote an article and recorded a video to explain the logic behind this dashboard: http://exceleratorbi.com.au/power-bi-public-story-telling-is-pure-genius/.
He also attached an Excel file that contains all the measures used in this report at the end of his article.
(Attached also in my post).
Great visual dashbaord and i have a similar component to my dashbaord using Chiclet slicer but i'm unable to add images which are on the local drive. I have checked the community boards/blogs but everyone has mentioned that images can be accessed through url only.
Kindly confirm if this is true!