How To Set Up Your Financial Reporting Data Within Power BI

How To Set Up Your Financial Reporting Data Within Power BI


Getting your financial reporting or financial analysis working well with Power BI requires your data to be set up in a particular way.

Many times when you get data out of a financial system, be it from the revenue side, the expense side or the balance sheet side; you need to re-arrange it in such a way that Power BI can utilize and run logic through it to be ultimately represented in a compelling report design.

That’s what this tutorial is all about. It’s to show you how you can do that, and how by doing these small setups or rearrangements of your raw data, you can actually start creating interesting and valuable reports around your financials.

This, historically, was very difficult to do. But, it’s becoming easier and more effecient with the many updates that are being rolled out with Power BI desktop.

Financial reporting within Power BI is becoming far superior to any alternative tool that you can utilize.

Therefore, with this tutorial, my goal is to show you how you can get it going, and also show you how you can make it cogent and really valuable for the consumers who might be utilizing it to make informed decisions.


***** Learning Power BI? *****
All Enterprise DNA TV Resources
FREE COURSE – Ultimate Beginners Guide To Power BI
FREE COURSE – Ultimate Beginners Guide To DAX
FREE – 60 Page DAX Reference Guide Download
FREE – Power BI Resources
Enterprise DNA Membership
Enterprise DNA Online


***Learn more about Enterprise DNA Membership***membership banner 3

3 comments on “How To Set Up Your Financial Reporting Data Within Power BI”

  1. Sam – good post. I have created a Power BI report similar to your report. It works great to make comparison against budget by department by period. Also going to setup user level security to give department users their respective access to their department and eventually deploy to on premises Power BI report server. Question…I am trying to figure out how to add commentary section to financial model. For each account there will be a favorable(Un-Favorable) variance of budget against actual. I want to be able to add a comment line based on threshold (+/- 10% ) of budget. So for example if Salaries are budgeted at $100K and actual are $120K we are unfavorable $20K and 20%. I want to include a comment line to say ” Overtime hours higher than plan due to new product released”.
    Any suggestions on how to accomplish this would be appreciated.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.