I know these are not the most politically correct words; however, we cannot build a real Income Statement in Power BI the way we can in Excel. The best we can do is put together something that looks like an Income Statement and hope that our CFO will accept it, knowing very well, that there is no chance that he or she will love what we deliver. The reason for that is that we just simply don't have all the formatting options that we have in Excel to properly format every line of our P&L, not to mention the drill down experience that we can provide in Excel.
However, we do not have an option, we must do what we can in Power BI, so here you go, I will demonstrate one way to fake it (and there are many). This will work well enough, although I will keep praying that Microsoft can develop a visual that will actually make this task easy for us to do.
You can download the PBIX file if you follow the link to my blog below...
Link to blog post: businessintell...
Негізгі бет How to Fake an Income Statement in Power BI
No video
Пікірлер: 34