Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All,
I have got a new reuirement wireframe , which is a P & L report. I was not able to figure out , if teh requirement is achievable or not If yes, how? I tried with matrix & inforover visuals, can anybody help me with my questions by taking a look at wirframe?
breifly ,
1. rows will have upto 4 levels. highlighted in blue/green are level 1
2. the rest of the values on rows in wirframe are level 2
3. on columns , I have to show MTD , YTD values for the selected month starting current year to last 4 years
4. YTD columns have to have expand /collapse option to go till month level (can see starting from N column)
5. columns H, I , J , AA, AB , AC are calcualted, formula : (G8-C8)/C8
6. Row no 16, is calculated row based on above category totals, I have many such calculated rows if I scroll down on the wireframe
Thanks in advance
Sandhya
This is precisely the reason why it is important to create a dashboard wireframe before actually creating a proper dashboard. Wireframes help in making you understand if a dashboard actually conveys your ideas well or not. You can take help from powerful dashboard wireframing tools like Mokkup. With its drag and drop feature, youll be able to create a dashboard wireframe in minutes, and it will save you so much time and effort. Hope this tip helps!
Hi @Anonymous ,
Check this blog post
https://blog.enterprisedna.co/how-to-create-profit-and-loss-statements-in-power-bi/
There are several examples online.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsCovering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
99 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |