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! Learn more
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. 
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.