Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
Anonymous
Not applicable

P&L with different Hierarchy and Gross Profit Calculation

Hi,

 

I am trying to build a PBI visualization of my P&L. It normally should be like this:

Desired P&L View.png

 

Since my database has only account, dates and amounts values I am connecting to an Account Mapping that I would leave on the excel file.

The result I get so far is this one:

Wrong P&L View.png

As you can see, since the mapping has Sold Units on 2 levels, it appears twice. For Sales is the same case, it appears twice.

 

And last but not least, I would like to calculate Gross Profit and Gross Margin below those lasts fields on the same table. I tried to calculate it and insert the field on "Values" but it shows a line under every single line.

 

I am attaching the excel file and the Power BI file on the comments

 

Thanks for your help

3 REPLIES 3
Anonymous
Not applicable

Do you guys know how to attach my excel file and my PBI dashboard?

Hi @Anonymous ,

You can upload the excel file and report file to OneDrive for Business  and share the link with us. Besides that, could you please also provide your expected result in form of table or screen shot? Thank you.

Best Regards

Rena

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

Hi Yingyinr,

 

Here is the drive link where you can find attached four files:

https://drive.google.com/drive/folders/1-2EWGjjEPcGGu49bjz_PsWB0CwuC0SK_?usp=sharing

 

  • Desired P&L View. Here is the usual visual I build for my P&L
  • Wrong P&L View. The result I get so far on my dashboard tests
  • DataBase. Here you will find the data base and the main mapping of the accounts
  • Dummy PBI. The dashboard with the main idea of the issue

Thanks for your support!

 

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.