skip to main content
  • Products
    • What is Power BI
    • Why Power BI
    • Power BI Desktop
    • Power BI Pro
    • Power BI Premium
    • Power BI Mobile
    • Power BI Embedded
    • Power BI Report Server
  • Pricing
  • Solutions
    • Customer showcase
    • Partner showcase
    • Data Stories
    • Power BI Visuals
  • Partners
    • Overview
    • Partner showcase
    • Find consulting services
    • Find a partner
    • Become a partner
  • Learn
    • Overview
    • Guided learning
    • Documentation
    • Support
    • Developer center
    • Community
    • Roadmap
    • Give feedback
    • Webinars
    • Blog
  • Community
    • Overview
    • Forums
    • Galleries
    • Ideas
    • Issues
    • Events
    • User groups
    • Community blog
  • Sign in
  • Sign up free
  • Products
    • What is Power BI
    • Why Power BI
    • Power BI Desktop
    • Power BI Pro
    • Power BI Premium
    • Power BI Mobile
    • Power BI Embedded
    • Power BI Report Server
  • Pricing
  • Solutions
    • Customer showcase
    • Partner showcase
    • Data Stories
    • Power BI Visuals
  • Partners
    • Overview
    • Partner showcase
    • Find consulting services
    • Find a partner
    • Become a partner
  • Learn
    • Overview
    • Guided learning
    • Documentation
    • Support
    • Developer center
    • Community
    • Roadmap
    • Give feedback
    • Webinars
    • Blog
  • Community
    • Overview
    • Forums
    • Galleries
    • Ideas
    • Issues
    • Events
    • User groups
    • Community blog
  • Sign in
  • Sign up free
  • Register
  • ·
  • Sign In
  • ·
  • Help
Go To
  • Galleries
  • Gallery Forum
  • Themes Gallery
  • Data Stories Gallery
  • R Script Showcase
  • Webinars and Video Gallery
  • Quick Measures Gallery
  • MBAS Gallery
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
  • Microsoft Power BI Community
  • Galleries
  • Data Stories Gallery
  • Income Statement with Ratio Analysis

Income Statement with Ratio Analysis

09-14-2019 16:02 PM

rsaprano
Advisor
1090 Views
LinkedIn LinkedIn Facebook Facebook Twitter Twitter
Highlighted
rsaprano
rsaprano
Advisor

Income Statement with Ratio Analysis

  • Mark as New
  • Bookmark
  • Subscribe
  • Mute
  • Subscribe to RSS Feed
  • Permalink
  • Print
  • Email to a Friend
  • Report Inappropriate Content
‎09-14-2019 04:02 PM

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

IncomeStatementThumbail.png
Income Statement.pbix
Labels:
  • Business
  • Economics
  • How To
  • Other
Message 1 of 1
1,090 Views
3
Reply
  • All forum topics
  • Previous Topic
  • Next Topic

Power Platform

  • Overview
  • Power BI
  • Power Apps
  • Power Automate
  • Power Virtual Agents
  • Sign in
  • Sign up

Browse

  • Solutions
  • Partners
  • Consulting Services

Downloads

  • Power BI Desktop
  • Power BI Mobile
  • Power BI Report Server
  • See all downloads

Learn

  • Guided learning
  • Documentation
  • Support
  • Community
  • Give feedback
  • Webinars
  • Developers
  • Blog
  • Newsletter
  • © 2019 Microsoft
  • Privacy & cookies
  • Terms of use
  • Trademarks