Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Income Statement

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

 

  • 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

1 Reply

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee

    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