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:

1

 Example Columns

2

 

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

clip_image006

Monthly report

image

Cash Flow Report

image

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.