Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
12-03-2022 23:45 PM - last edited 12-04-2022 22:47 PM
Power BI how to create and format financial Profit and Loss (PnL) Statements. Traditional income statements, P&L, and Balance sheets have a format with blank rows in between, and custom totals across rows.
You can find the detailed steps below.
The purpose of this video is to show you how extended dimensions can help you to create a formatted financial statement, and how you can create custom totals if you are interested in obtaining that kind of format
How to get Pages 2 and 3
The source file is available at: https://github.com/amitchandakpbi/powerbi/blob/main/P%26L%20Data.xlsx
My Medium blog can be found here if you are interested
Click here to access all my blogs and videos in a jiffy via an exclusive glossary using Power BI. Please like, share, and comment on these blogs. I would appreciate your suggestions for improvement, challenges, and suggestions for topics so that I can explore these in more depth.
There is a Power BI tutorial series that you can watch on my channel. Make sure you subscribe, like, and share it with your friends.
Master Power BI
Expertise in Power BI
Power BI For Tableau User
DAX for SQL Users
eyJrIjoiMzAyN2YxOGYtNmMzMS00MTk0LTgyZWEtMGU0OTVjOTk1MWQ0IiwidCI6ImVhOGJkMWZkLWFjMzQtNGFlMi1iNDIxLTZjZmEyZmNmZjI0MyJ9
Thank you for your effort, but I'm still amazed in 2023 with so many solutions in data viz, PowerBi offer on PL statement is so poor.