Forum Discussion
Measure unaffected by Dimensions
Hi Power BI Community
I am trying to build a Profit & Loss and Balancesheet inside Power BI. I have my fact table with all my transactions and a dimension table with the account names.
I have a visual issue with the Balance sheet. I am trying to display the total Nett/Profit loss from the Profit & Loss table as 1 row in my Balance sheet, but becuase I use the Account names from my DimTable as rows in my Matrix visual it shows the different Profit & Loss accounts as well.
Here is example:
As you can see this includes P&L accounts and also Equity accounts like Retained earnings. I want to group all P&L accounts, but still show the balance sheet accounts as seperate rows.
Thanks in advance for the help.
1 Reply
- amitchandakSuper User
Ruan-BFI , somehow with the screenshot I am not able to get your issue.
Can you please explain with an example.
This is a good article on financial if that can help
https://community.powerbi.com/t5/Desktop/Traditional-Financial-Statements/td-p/7223
Appreciate your Kudos.