skip to main content
Power BI
    • What is Power BI
    • Why Power BI
    • Customer stories
    • Data visuals
    • Security
    • Power BI Desktop
    • Power BI Pro
    • Power BI Premium
    • Power BI Mobile
    • Power BI Embedded
    • Power BI Report Server
  • Pricing
    • Azure + Power BI
    • Microsoft 365 + Power BI
    • Dynamics 365 + Power BI
      • Energy
      • Healthcare
      • Manufacturing
      • Media
      • Retail
    • For analysts
    • For IT
      • Overview
      • Embedded analytics
      • Power BI visuals
      • Automation
      • Documentation
      • Community
    • Partners Overview
    • Solutions Partners
    • BI Specialized Partners
    • Power BI CSOs
    • Fabric Partner Community
    • Training
    • Getting started
      • Overview
      • Self-guided learning
      • Webinars
      • Documentation
      • Roadmap
      • Overview
      • Issues
      • Give feedback
    • Blog
    • Business intelligence topics
    • Overview
    • Forums
    • Galleries
    • Submit ideas
    • Events
    • User groups
    • Community blog
    • Register
    • ·
    • Sign in
    • ·
    • Help
    Go To
    • Power BI forums
    • Updates
    • News & Announcements
    • Get Help with Power BI
    • Desktop
    • Service
    • Report Server
    • Power Query
    • Mobile Apps
    • Developer
    • DAX Commands and Tips
    • Custom Visuals Development Discussion
    • Health and Life Sciences
    • Power BI Spanish forums
    • Translated Spanish Desktop
    • Power Platform Integration - Better Together!
    • Power Platform Integrations
    • Power Platform and Dynamics 365 Integrations
    • Training and Consulting
    • Instructor Led Training
    • Galleries
    • Community Connections & How-To Videos
    • COVID-19 Data Stories Gallery
    • Themes Gallery
    • Data Stories Gallery
    • R Script Showcase
    • Webinars and Video Gallery
    • Quick Measures Gallery
    • 2021 MSBizAppsSummit Gallery
    • 2020 MSBizAppsSummit Gallery
    • 2019 MSBizAppsSummit Gallery
    • Events
    • Ideas
    • Custom Visuals Ideas
    • Issues
    • Issues
    • Events
    • Upcoming Events
    • Community Engagement
    • T-Shirt Design Challenge 2023
    • Community Blog
    • Power BI Community Blog
    • Custom Visuals Community Blog
    • Community Support
    • Community Accounts & Registration
    • Using the Community
    • Community Feedback
    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: 

    Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

    • Power BI forums
    • Galleries
    • Data Stories Gallery
    • Income Statement with Ratio Analysis

    Income Statement with Ratio Analysis

    09-14-2019 16:02 PM

    rsaprano
    MVP
    14614 Views
    LinkedIn LinkedIn Facebook Facebook Twitter Twitter
    rsaprano
    rsaprano
    MVP
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    Income Statement with Ratio Analysis

    ‎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

    Preview file
    325 KB
    Income Statement.pbix
    Labels:
    • Labels:
    • Business
    • Economics
    • How To
    • Other
    Message 1 of 4
    14,614 Views
    10
    Reply
    • All forum topics
    • Previous Topic
    • Next Topic
    dupton
    dupton
    Regular Visitor
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎03-11-2020 10:40 AM

    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.

    Message 3 of 4
    12,264 Views
    0
    Reply
    rsaprano
    rsaprano
    MVP
    In response to dupton
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎03-11-2020 10:47 AM
    Hi - how all the elements on the front page are built (including the waterfall) is detailed at https://community.powerbi.com/t5/Community-Blog/Income-Statement-Analysis-Part-1-of-5/ba-p/841598
    Message 4 of 4
    12,258 Views
    0
    Reply
    Anonymous
    Not applicable
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎12-16-2019 04:34 PM

    These dashboards are elegant. And the presentation at Power User Days was very informative. Thank you!

     

    David (Portland, Oregon)

    Message 2 of 4
    13,499 Views
    0
    Reply

    Power Platform

    • Overview
    • Power BI
    • Power Apps
    • Power Pages
    • 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

    © 2023 Microsoft

    Follow Power BI

    • Privacy & cookies
    • Manage cookies
    • Terms of use
    • Trademarks
    Consumer Privacy Act (CCPA) Opt-Out Icon Your Privacy Choices