cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Frequent Visitor

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

 

1 ACCEPTED SOLUTION

Accepted Solutions
Microsoft
Microsoft

Hi @AhmedJ,

 

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

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

1 REPLY 1
Microsoft
Microsoft

Hi @AhmedJ,

 

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

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
November Update

Check it Out!

Click here to read more about the November 2020 Updates!

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

secondImage

Power Platform October Community Highlights

Check out the top community contributors across all of the communities

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors