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
    • Office 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
    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
    • The Financial Visuals Reference – Management Repor...

    The Financial Visuals Reference – Management Reporting in Power BI

    03-14-2019 08:08 AM

    klabir
    Helper V
    6785 Views
    LinkedIn LinkedIn Facebook Facebook Twitter Twitter
    klabir
    klabir Helper V
    Helper V
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    The Financial Visuals Reference – Management Reporting in Power BI

    ‎03-14-2019 08:08 AM

    In the Past there were no standards in Reporting at all which lead to sometimes horrible and unreadable Reports with a lot of 3D-, Pie-, Gauge Charts and no meaningful colors as well. Some time ago the IBCS was introduced and set some standards especially for the finance and controlling area. We can discuss about every single design point here, it does not really matter in the end. Important is to follow the general concepts and rules. Create a standard which fits for your organization’s needs, follows best practice and make sure it will be consequently used.

     

    I created the first Draft of “The Financial Visuals Reference - Management Reporting in Power BI”. In this initial Version, I want to focus on KPI Cards which can show the status of a measure by comparing key indicators to a target and/or previous year. Then we go through some methods to show absolute values like Revenue or Costs, percent values like Margins and Variances, Human Resource KPIs like FTE's ( Full Time Equivalents) and Headcounts. Contributions like a Profit and Loss Statement. Comparisons for Gain and Loss of Customers or Revenue versus Costs. Last but not least the concept of small multiples in Management Reporting. We can discuss about every single design point here, it does not really matter in the end. Important is to follow the general concepts and rules. Colours are up to somebody’s preference, they should have just a meaning. Create a standard which fits for your organization’s needs, follows best practice and make sure it will be consequently used.

     

    Klaus Birringer

    https://dataviz.boutique

     

    Please note that I used RAND() Function to generate dummy values heavily. So Charts look always different on reload / refresh. If you see a ugly chart, just reload the page.

    eyJrIjoiMGJkY2M0NDEtZjY0NC00NWM5LTk3YjYtOTU2ZDk0YTI3ZmJhIiwidCI6IjJlYmI3YTRhLTk2YTYtNDVhYy1hNWFmLTdjOWQ5NjUyMGFjYiIsImMiOjh9

    Preview file
    293 KB
    Labels:
    • Labels:
    • Business
    • Data Science
    • Economics
    • Education
    Message 1 of 4
    6,785 Views
    5
    Reply
    • All forum topics
    • Previous Topic
    • Next Topic
    olziich36
    olziich36
    New Member
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    ‎11-01-2019 03:06 AM

    Hi 

    can you share the Pbix file for this?
    olziich36@gmail.com

    Message 3 of 4
    4,788 Views
    1
    Reply
    klabir
    klabir Helper V
    Helper V
    In response to olziich36
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    ‎11-01-2019 03:18 AM

    Hello

     

    https://appsource.microsoft.com/en/marketplace/apps?search=ultimate&product=power-bi-visuals

     

    you can download the sample pbix files from above Link / visuals. it is basically the same.

    HTH

    Klaus

    https://datadriven.pro

    https://dataviz.boutique

     

    Message 4 of 4
    4,781 Views
    0
    Reply
    Adam_Defries
    Adam_Defries Helper I
    Helper I
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    ‎10-16-2019 04:32 PM

    Hi 

    can you share the Pbix file for this?

    Message 2 of 4
    4,955 Views
    0
    Reply

    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

    © 2022 Microsoft

    Follow Power BI

    • Privacy & cookies
    • Manage cookies
    • Terms of use
    • Trademarks