top of page
Writer's pictureLachlan McLeod

Power BI Update: October 2024 – New Insights in Financial Reporting for Firms

Updated: 38 minutes ago

The October 2024 Power BI update introduces several powerful new features designed to enhance users' reporting, visualisation, and data organization capabilities. From enhanced reporting tools to smarter data organisation, here’s a breakdown of the latest features and why they matter to accounting professionals.


Enhanced Power BI Report Creation with Copilot (Public Preview)

Power BI’s Copilot just got a major boost in understanding user needs. It now offers improved contextual awareness, making report creation more intuitive and aligned with user needs. This update makes creating precise, tailored reports faster and more intuitive, turning report-building into a guided experience.


Why This Matters:

  • Captures essential report details upfront, minimising errors and maximising relevance.

  • Offers transparency with Page Outline, so accountants can see exactly what’s in the report.


Bottom Line: This update eliminates the guesswork involved in report creation, helping firms generate accurate, compliant, client-specific reports faster.


Dynamic Format Strings for Measures (Generally Available)

With dynamic format strings, Power BI now lets your numbers shift format automatically based on context—bringing financial data presentation to a whole new level.

Used with permission from Microsoft.

Why This Matters:

  • Ensures data clarity by adapting format on the fly, making reports cleaner and more contextually relevant.

  • Enables seamless transitions between currencies, percentages, or units, tailored to client needs.


Bottom Line: Firms can now provide tailored, polished insights that dynamically fit each client’s unique reporting requirements.


INFO.VIEW DAX Functions

Say goodbye to manual documentation. INFO.VIEW DAX functions make it easy to track metadata changes in real time, providing an automatic log for your data model and improving transparency.

Used with permission from Microsoft.

Why This Matters:

  • Ensures all relationships, measures, and columns are clearly documented and up to date.

  • Supports auditing by making model metadata easy to access and review.


Bottom Line: With self-documenting models, firms can streamline their audit processes and ensure consistent data handling across complex financial reports. This feature supports internal review processes, allowing accountants to track and verify model changes effortlessly, ensuring data integrity over time.


Visual Calculations Update – Combo Charts and Field Parameters

The combo charts update adds powerful visual calculations, while field parameters make it easier than ever to highlight trends dynamically.

Used with permission from Microsoft.

Why This Matters:

  • Provides flexibility to visualise trends, such as moving averages, within combo charts.

  • Allows quick switching between different data attributes, enhancing the storytelling power of financial reports.


Bottom Line: This update makes it simple for firms to showcase year-over-year trends or quarterly comparisons with visuals that adapt to data needs.

 

Azure Map Update – Data Bound Reference Layers

Power BI’s mapping capabilities just levelled up with data-bound reference layers, allowing geographic data to become interactive and layered with business insights.

Used with permission from Microsoft.

Why This Matters:

  • Allows accountants to explore branch-level revenue trends or analyse location-based data with greater depth.

  • Adds a dynamic, geographic lens to financial reports, enhancing insights for clients with multi-location operations.


Bottom Line: This update helps firms offer geographically segmented financial insights, bringing depth to region-specific analyses. For example, it can support branch-level financial assessments or revenue analysis based on geographic variations, adding another layer of depth to client reports.


New List Slicer (Preview)

The New List Slicer brings a clean, hierarchical view to data filters, helping accountants get straight to what matters in multi-dimensional reports. It enables more advanced filtering with hierarchical data, image display, and customisable selection options.

Used with permission from Microsoft.

Why This Matters:

  • Organizes data by hierarchy, such as region, department, or cost centre, making complex datasets manageable.

  • Adds visual appeal and improves usability with customisation options that create intuitive, easy-to-navigate reports.


Bottom Line: The List Slicer is a must-have for clear, hierarchical organisation of financial data, improving navigation and making reports more client-friendly.

 

October’s Power BI updates deliver key improvements for firms looking to enhance their reporting capabilities, from more dynamic data presentation to advanced filtering and transparent report creation. Each feature supports greater accuracy, flexibility, and ease of use, making financial reporting faster and more insightful for clients. By integrating these new tools, firms can improve the client experience with tailored insights, transparent data modelling, and easy-to-navigate reports that bring financial data to life.

Comentários


bottom of page