Showing results for 
Search instead for 
Did you mean: 
New Member

Need help - For creating a dashboard using P&L summary

Hi Everyone ,


I am fairly new to the PowerBI. I have a requirement from my boss to create a dashboard through Power BI based on below data. I have the below summary data in excel which includes formulas but when I add it as a table and upload the data to powerbi desktop it will updload as it is even the totals considered as values . I need to show the EBITDA in data cards department wise and Year to Date EBITDA month wise through a column chart. Below data is just for one month and i will have the similar table for the 12 months in total .


Please help !



Community Support
Community Support

Hi @dszrohan ,


Please provide the reproducible original data in table form and expected output results.


Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Super User IV
Super User IV


To build Financial Statements in Power BI, it requires some initial steps to structure your report template and DAX formulas for various p&L matrices.

Follow these links to learn more and adapt them to suit your needs.



If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Helpful resources


Happy New Year from Power BI

This is a must watch for a message from Power BI!

December Update

Check it Out!

Click here to read more about the December 2020 Updates!

Community Blog

Check it Out!

Click here to read the latest blog and learn more about contributing to the Power BI blog!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors