Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
smegha646
New Member

conditional formatting (for totals and percentage) in row subtotals in power bi

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 : smegha646_1-1716757866168.png

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 : smegha646_0-1716757771353.png

Please help in providing solution on how the data can be presented in form of ss2 

2 REPLIES 2
Anonymous
Not applicable

Hi @smegha646 ,

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. 
Capture.PNG
I have attached the screenshot by providing my comments on how it should be visible. 
Please let me know if you have any questions. 

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.

Users online (2,351)