Profitbase Profitbase Profitbase Profitbase
  • About Us
  • Blog
  • Careers
  • EN EN
    • no Norsk
  • Book a Demo
  • Products
    • Budgeting and Forecasting
    • Risk management
    • Consolidation
    • Power BI Visuals
      • Financial Reporting Matrix
      • Power BI Gantt Chart
  • Customers
    • Our customers
    • Customer Success
  • Partners
  • Resources
    • Guides
    • Videos
    Home BlogPower BI Financial Reporting v4 Has Expandable/Collapsible Columns

    Power BI Financial Reporting v4 Has Expandable/Collapsible Columns

    April 9, 2021
    Anders Aano
    Anders Aano
    Product manager - Profitbase Visual at Profitbase AS
    linkedin image

    — The #1 requested feature in Power BI 

    Expandable/Collapsible columns in Power BI Financial Reporting Matrix.

    Expandable/Collapsible columns in Power BI Financial Reporting Matrix.

     

    Expand and collapse your columns in Power BI

    We are pleased to announce that the now-released Power BI Financial Reporting Matrix v4 has expandable and collapsible columns with summarization.

    This is the number one requested feature in Power BI because it adds plenty of flexibility and the possibility to create great financial reports. People have used this functionality when creating financial reports in Excel for years, and it’s now finally possible in Power BI.

    >> Watch the new features demo

    >> Read Microsoft’s article on the benefits


    New features in version 4:

    >> Download v4 (license key required)

    Expandable and collapsible columns with summarization

    The highly requested expand and collapse column feature enables users to drill and summarize along both rows and columns. You can now group and summarize both vertically and horizontally, for example, by date or product categories, just like you can in “good old” Excel.  Collapsed columns will automatically be summarized without any configuration or modeling required.

    All in all, this Power BI financial reporting feature gives users greater flexibility to present and analyze their data and create better financial reports in little time.

    Column expansion option available

    Column expansion option available.

     

    Fine-grained control of cell formatting

    We added support for the Format function, which enables formatting specific cells in a column. This feature provides even more fine-grained control to formatting your reports the way you want.

    Format function.

    Format function.

     

    Column header improvements

    Users can now enable grid lines for just the column headers. This feature makes it easy to view reports with multiple levels of columns, for example, Year, Quarter, Month.

    Enabling grid lines

    Enabling grid lines.

     

    Column headers for total columns can be customized using caption templating. This feature is useful when you want to customize the column captions of the collapsed subtotal columns. You would typically do this if you were in a non-English speaking country.

    Column headers are now always seen within the visible area of its group and screen, even while scrolling horizontally. This makes it easy to understand the context you are in when viewing a report.

     

    Get the latest version

    Download Power BI Financial Reporting Matrix v4. Register it as an organizational visual, then import the visual from your organization’s store.

    Note

    If you are using Power BI Desktop to create reports, make sure it is upgraded to the latest version (December 2020 or later). Power BI Financial Reporting Matrix v4 requires at least version 3.5 of the Power BI API, which is only supported by the December 2020 version or later.

     

    Bug fixes

    Bug fixes for version 3.0.5

    • Applying a selection when the visual is already pre-filtered now works
    • If rows with the same ID/name appears multiple times under different parents, the subtotals and row styling feature now work

     

    Create financial statements easily

    Watch our tutorial on how easy it is to make a basic P&L or income statement with the Financial Reporting Matrix.

    The Financial Reporting Matrix is a custom visual for creating financial reports in Power BI that complies with financial reporting standards. It can be downloaded from Microsoft Marketplace and enables users to easily create reports such as P&L, income statements, balance sheets, or any tabular report, which require fine-grained control over formatting, calculations, and layout.

    The tool supports features such as conditional formatting, row and column expansion, summarization and custom subtotals, styling and formatting rows, columns and cells, custom columns, calculations, and much more. The tool is the fastest – and often the only way – to make accurate financial reports in Power BI. You can now create reports in Power BI that were only possible using Excel before. Make it happen in Power BI is by using this visual today.

     

    Videos

    Power BI Financial Reporting Matrix 4.0 video

    Watch our video on new features in the Power BI Financial Reporting Matrix 4.0.


    Make a basic P&L income statement

    Watch how to make a basic P&L or income statement.

     

    Keep updated

    Subscribe (English or Norwegian) to the Profitbase newsletter to get notified about future updates. 

    Share:
    image image image
    Tags:
    Business IntelligencePower BI

    Subscribe to the Profitbase newsletter

    Free quarterly email that delivers valuable information to business professionals

    Subscribe
    Related Insights
    Why Gantt charts and Power BI is a match made in heaven
    Blog
    March 15, 2023 Why Gantt charts and Power BI is a match made in heaven
    “Low-Code is the way,” says Head of Research & Development at Profitbase
    Blog
    January 24, 2023 “Low-Code is the way,” says Head of Research & Development at Profitbase
    The need for speed: The solution to the dilemma of thought through vs carried out decisions
    Blog
    January 17, 2023 The need for speed: The solution to the dilemma of thought through vs carried out decisions
    Profitbase
    • Stokkamyrveien 13, 4313 Sandnes
    • Martin Linges vei 25, 1364 Fornebu, Oslo
    +47 970 64 000 post@profitbase.com
    • Privacy Policy
    • Careers
    • Receive our newsletter
    • Copyright notice

    Follow us:

    • twitter
    • youtube
    • linkedin
    • facebook
    © 2022 Profitbase
    Profitbase
    • Products
      • Budgeting and Forecasting
      • Risk management
      • Consolidation
      • Power BI Visuals
        • Financial Reporting Matrix
        • Power BI Gantt Chart
    • Customers
      • Our customers
      • Customer Success
    • Partners
    • Resources
      • Guides
      • Videos
    • About Us
    • Blog
    • Careers
    • EN EN
      • no Norsk
    Profitbase
    • Book a Demo
    We use cookies to ensure that we give you the best experience on our website. If you continue to use this site we will assume that you are happy with it.Ok