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
      • Energy
      • Healthcare
      • Manufacturing
      • Media
      • Retail
    • For analysts
    • For IT
      • Overview
      • Embedded analytics
      • Power BI visuals
      • Automation
      • Documentation
      • Community
    • Overview
    • Find consulting services
    • Partner showcase
    • Find a partner
    • Become a partner
    • Instructor-led training
    • Getting started
      • Overview
      • Online workshops
      • 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
    • 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
    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
    • Power BI Formatted Profit and Loss Statement

    Power BI Formatted Profit and Loss Statement

    12-03-2022 23:45 PM - last edited 12-04-2022 22:47 PM

    Super User amitchandak
    Super User
    1779 Views
    LinkedIn LinkedIn Facebook Facebook Twitter Twitter
    amitchandak
    Super User amitchandak
    Super User
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    Power BI Formatted Profit and Loss Statement

    ‎12-03-2022 11:45 PM

    Power BI Formatted Profit and Loss Statement

     

    Power BI how to create and format financial Profit and Loss (PnL) Statements. Traditional income statements, P&L, and Balance sheets have a format with blank rows in between, and custom totals across rows.

     

    You can find the detailed steps below.

    The purpose of this video is to show you how extended dimensions can help you to create a formatted financial statement, and how you can create custom totals if you are interested in obtaining that kind of format

     

     

     

     

    How to get Pages 2 and 3

     

    The source file is available at: https://github.com/amitchandakpbi/powerbi/blob/main/P%26L%20Data.xlsx

     

    My Medium blog can be found here if you are interested

    Click here to access all my blogs and videos in a jiffy via an exclusive glossary using Power BI. Please like, share, and comment on these blogs. I would appreciate your suggestions for improvement, challenges, and suggestions for topics so that I can explore these in more depth.

    There is a Power BI tutorial series that you can watch on my channel. Make sure you subscribe, like, and share it with your friends.

    Master Power BI
    Expertise in Power BI
    Power BI For Tableau User
    DAX for SQL Users

     

     

     

     

     

     

     

    eyJrIjoiMzAyN2YxOGYtNmMzMS00MTk0LTgyZWEtMGU0OTVjOTk1MWQ0IiwidCI6ImVhOGJkMWZkLWFjMzQtNGFlMi1iNDIxLTZjZmEyZmNmZjI0MyJ9



    Learn Power BI - Full Course with Dec-2022, with new DAX functions like Window, Index, Offset !!
    Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!
    Formatted Profit and Loss Statement with empty lines
    Labels:
    • Labels:
    • Business
    • Education
    • How To
    Message 1 of 1
    1,779 Views
    5
    Reply
    • All forum topics
    • Previous Topic
    • Next Topic

    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
    California Consumer Privacy Act (CCPA) Opt-Out Icon Your California Privacy Choices