Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
I have a matric in power bi(ss1 shown below). Currently, the data is grouped in rows, and at the end of each group, subtotal column is shown(ss1).
ss1 :
Now i need to present above report in below format where i want to format subtotal of 1-2 of the groups, and need to show % instead of addition, for others it should show as total only There is a formula for % which I need to write..
ss2 :
Please help in providing solution on how the data can be presented in form of ss2
Hi @Anonymous ,
I'm a little confused about your needs, Could you please explain them further? It would be good to provide a screenshot of the results you are expecting and desensitized example data.
Thanks for your efforts & time in advance.
Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous
Thank you very much for your response.
I have attached the screenshot by providing my comments on how it should be visible.
Please let me know if you have any questions.
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
| User | Count |
|---|---|
| 97 | |
| 71 | |
| 50 | |
| 47 | |
| 44 |