Income Statement

[Anonymous]

What is the best way to set up an income statement view in power bi.

Is there any income statement visual available already or do I need to build this up? I want to see it with subtotals along the way. So and example could be:

Sales                     xxxxx

Cost of Sales        (xxxxx)

Gross Profit            xxxx

Fixed Costs            (xxxx)

Salaries                  (xxxx)

Opex                      (xxxx)

Operating Profit     xxxxx

Other income          xxxx

Profit before tax      xxxx

Tax                           (xxx)

Net Profit                xxxx

Something like that.

Thank you for your help

[v-yulgu-msft · Accepted solution]

Hi @Anonymous,

There is no such a visual to directly show income statement currently. You may have to generate measures/calculated columns to get desired result.

Regards,

Yuliana Gu