Power BI Desktop - Group Rows in Table Visualization

[Arora_Sangeet]

I am working on a Tabular Report where I am getting the data as - 

TextCol1	TextCol2	TextCol3	TextCol4	NumericCol5
A	AB	ABC	D1	1
A	AB	ABC	D2	2
A	AB	ABC	D2	3
A	AB	ABC	D4	4

But I want to Merge/Group the row data in the first 3 columns as below -

I tried using the Matrix stepped layout but couldn't achieve the exact format. Can anybody explain how to achieve this functionality using table or Matrix.

[amitchandak · Accepted solution]

@Arora_Sangeet , refer this

https://www.burningsuit.co.uk/blog/2019/04/7-secrets-of-the-matrix-visual/

https://docs.microsoft.com/en-us/power-bi/visuals/desktop-matrix-visual

[v-juanli-msft · Accepted solution]

Hi @Arora_Sangeet 

Please check details of format the matrix in my pbix.

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak · Accepted solution]

@Arora_Sangeet , refer this

https://www.burningsuit.co.uk/blog/2019/04/7-secrets-of-the-matrix-visual/

https://docs.microsoft.com/en-us/power-bi/visuals/desktop-matrix-visual

[AllisonKennedy]

@Arora_Sangeet  Did you try turning off the stepped layout? You may also have to play with which fields are summarized, and could try this in a table visualization as well depending on your data, and as you add the columns to the 'values' click the down arrow to determine if they should be 'don't summarize' or 'sum' or something different.

With the table you'll get the subheadings repeating, with the matrix you'll get something similar to (so will have one extra row of headings from what you want): 

 You can always play with font colour for headings and add shapes if really needed. 

Has this post solved your problem? Please mark it as a solution so that others can find it quickly and to let the community know your problem has been solved. 

If you found this post helpful, please give Kudos.

I work as a trainer and consultant for Microsoft 365, specialising in Power BI and Power Query. 

https://sites.google.com/site/allisonkennedycv