The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
This report shows a completed example of a flexible, dynamic and attention-focused Income Statement Report. It was built for and demonstrated at the innagrual Power User Days Finance event in London (July 2019) which brought together finance professionals who are interested in learning more about how the Power Platform can help with their role.
The report consists of 3 key report pages:
1) Income Statement: The key financial metrics are shown as cards at the top (along with up/down arrows and previous period values for context). Also included is an Income statement in a variety of formats (Fixed tabular format, Measure comparison with pivot-table style functionality and a breakdown by region across columns), and a waterfall chart which shows the contribution of each region to the change in value for the period selected. By Default this shows for Net Profit though if another line on the IS is selected the waterfall chart will reflect this line instead. The slicers at the top for year/month and MTD/QTD/YTD affect all the visuals on the page - the metrics, IS and waterfall chart can be viewed as monthly, quarter to date or year to date values for any selected month.
2) Ratio Analysis: This allows the user to focus on a particular financial ratio (e.g. Cost/Income Ratio, Gross Margin) and see how this ratio has changed since last year. The user can then drill into the drivers behind that change, looking at a breakdown of current vs prior year values by region, a country breakdown plotting the measure against revenue (for context of size), and a view of the ratio over time. The charts are chosen specifically to interact with eachother - e.g. selecting a region on the bullet chart (By OK Viz) updates the scatter chart to see a comparison between the countries within the region and to then see how the value has changed vs prior year by month on the line chart/see how the Income statement looks for that particular area of focus.
3) Planning: This utilises the Val Q Scenario Planning custom visual with a decomposition tree for a given metric/Income statement line and the ability to view it under different scenarios.
This report was highlighted as part of a presentation on Storytelling With Data which I presented at the Power Platform World Tour London in August 2019. To view a recording of this session see below/here
eyJrIjoiZTVkNjlkMDItYTk5Yy00M2RiLWJmMjYtM2Y4ZWViNDA0NDYyIiwidCI6IjBjNzk5ZDM4LTQ3NjQtNDJiYy1iNGZmLTIzYmViYTljN2ZlMiIsImMiOjh9
Hi - do you mind providing some information on how you were able to show the waterfall with month start and month end? I'm trying to achieve similar results, but when I filter to a specific month it'll only show one single bar as a reference point. Thanks.
These dashboards are elegant. And the presentation at Power User Days was very informative. Thank you!
David (Portland, Oregon)