Could we create Table with grouping rows as mention in image.?

[Shloka_Lakhani]

Hello,

I want this type of table in powerbi desktop. as i created same using powerbi paginated report. but need to display in dashboard.
can you please help me?

[Shloka_Lakhani]

Hi @amitchandak ,

But i just want without subtotal and total. i need cell grouping as per image. as there is one coupon used in multiple orders. so first 8 rows indicates coupon infromation and last rows indicates orders. at last just multiple entry for coupon need to remove and shown as single row.

[amitchandak]

@Shloka_Lakhani , You can use matrix visual and you can switch off some subtotals as per need.

Also, Switch off the stepped layout.

Power BI how to show/hide subtotal, grand total| Matrix Per Row Level

https://youtube.com/shorts/kVmQxecQ-BY