Documentation Financial Visual (Power BI)

WOW!!! Finally we have a financial reporting visual that does what a financial person wants for reporting.

Our Visual are highly configurable, and below are some of the examples of the configurations you can do:

  • Have totals below or above the actual posting accounts
  • Different levels in the hierachy
  • Headline for each group if you have total at bottom of the group.
  • Format negative numbers
  • Matrix or table formatting
  • Expand to a certain level.
  • Tooltips as a list of postings.
  • Drillthrough
  • Postfix total for totals (e.g. TOTALS in the end of the account text).
  • A lot of formatting options
  • Multi measures and individual formatting
  • Hide blank rows
  • Total column in front or after the columns
  • Define how to aggregate the Total Column
  • Define what Measures to see in the total column
  • And much more

How to install it

Simply go to app source from Microsoft Power BI and download it.

Pricing

  • 14 days free trial.
  • Pricing per user
    • 1-5 users: 5 USD per user per month (Excl. VAT)
    • 6-20 users: 4 USD per user per month (Excl. VAT)
    • 21-100 users: 3 USD per user per month (Excl. VAT)
    • 100-250 users: 2 USD per month (Excl. VAT)
    • 250+ Users: 1.75 USD per month (Excl. VAT)

Prerequisites

This is a recursive visual, so it needs a special structure in the data table. Two things are important to have it to work:

  1. Your data (Financial accounts) must have at least two fields
    • No. – The actual account No.
    • Parent No. – The account the Account belongs to.
  2. Then it can have (Financial accounts):
    • Name for Posting accounts (that could e.g. be a column with Account No+ ‘ ‘+Account Name)
    • Name for totals (that could e.g. be a column with just Account Name)
  3. The measures that you use should be implicit measures and it should follow this guideline
    • Finance amount = If(sum(amount)=0,0,sum(amount))
    • Call it what ever you want, but it must make sure that all accounts are returned no matter if there are postings on it or not.
  4. All other measure can then build on this measure and then it will work. Example
    • Finance amount LY = calculate([Finance amount], sameperiodlastyear(Dates[Date])

That’s it. If your datamodel looks like that, then it will work. Especially 3 is important to get the recursion to work.

How to use it

Well, just like any other visuals then try it. Basically there are two things you must setup:

  1. Fields
  2. Formatting

The fields marked with yellow is mandatory. If you want a matrix, then use Columns also (e.g. for month names).