sub heading

Question

I'm a Power BI newby - I would like to create a simple report but can't see how to get sub headings and sub totals onto the report.&nbsp; How do I do this?&nbsp; Example of my data set:Type &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Garment &nbsp; &nbsp; &nbsp;CostOutdoor &nbsp; &nbsp; Coat &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 200Outdoor &nbsp; &nbsp; sweater &nbsp; &nbsp; &nbsp;&nbsp; 100Outdoor &nbsp; &nbsp; shoes &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 150Indoor &nbsp; &nbsp; &nbsp;&nbsp; shirt &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 75Indoor &nbsp; &nbsp; &nbsp;&nbsp; shoes &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 100Indoor &nbsp; &nbsp; &nbsp;&nbsp; socks &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 10&nbsp;The simple report formatting I want is:Type &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Garment &nbsp; &nbsp; &nbsp;CostOutdoor &nbsp; &nbsp;&nbsp; Coat &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 200&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; sweater &nbsp; &nbsp; &nbsp;&nbsp; 100&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; shoes &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 150&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; Total Outdoor &nbsp; &nbsp; 450&nbsp;Indoor &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; Shirt &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 75&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; shoes &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 100&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; socks &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 10&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; Total Indoor &nbsp; &nbsp; &nbsp; &nbsp; 185&nbsp;Grand Total &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 635&nbsp;

anonymous · Accepted Answer

Hi&nbsp;Anonymous,
&nbsp;
You can create a matrix with 'type', 'garment' as row fields, 'cost' as value fields, then expand row field and turn off 'stepped layout' to achieve your requirement.

Regards,
Xiaoxin Sheng

Forum Discussion

sub heading

1 Reply

Related content

Table with Headings and Sub-Headings

Matrix Column Head Order

Columns heading when exporting a Report Builder report to CSV

Double Heading Matrix

Different colours for column headings