insightsoftware Acquires Power ON

State of the Art Report Writer in Power BI

Back to Blog

State of the Art Report Writer in Power BI

Historically, BI Systems have lacked Financial Report Writers. Not anymore.
Power ON’s Financial Report Writer is built around 4 concepts:

·         Row Definitions

Define the lines and calculations in your report. Take advantage of advanced DAX Formulas or client side calculations

·         Column Definitions

Users can define QTD, YTD, Monthly, Budget vs Actual, Actuals to Current data, and Forecast for the remainder of the year? The calculations are user-defined.

·         Report Definitions

1 row and 1 column definition make up a Report. You can reuse both the Row and Columns in unlimited Reports.

·         Style Definitions

Underline/bold/font size/single line/double line/italic/font that can be re-user on one or many rows OR columns

Example Rows:


 Example Columns


Finished Reports

Pay attention to:

·         Both $, Headcount and % in the same column

·         Free layout

·         Client-side calculations

·         Respects any Power BI Slicer

·         Dynamic columns based on selected year, and month in year

·         Expand-Collapse rows

·         Running Totals

Forecast Report


Cash Flow Report


Note: Only available as part of the Power ON Visual Planner solution. The only solution with write-back and prediction capabilities to Tabular Models.

Contact us or send us an email to see more.