New user - simple request

[PowerBI87]

Hi all,

I have some data and created a table:

Company	Bundle	Year
XYZ CORP	Bronze	2021
ABC CORP	Silver	2019
GHI CORP	Gold	2018
LMN CORP	Gold	2019
XYZ CORP	Silver	2019
XYZ CORP	Silver	2020

I would like to display the table so that is shows up like this (without repeating values in column 1):

Company	Bundle	Year
XXZ Corp	Bronze	2021
	Silver	2019
	Silver	2020
ABC CORP	Silver	2019
GHI CORP	Gold	2018
LMN CORP	Gold	2019

Any adivise would be apprecitated.

Thanks.

[v-alq-msft · Accepted solution]

Hi, @PowerBI87 

Based on your description, you may create a matrix visual, go to 'Visualization' ribbon, click 'Format'=>'Subtotals', set 'Row subtotals' off, click 'Row headers', set 'Stepped layout' off.

Result:

Best Regards

Allan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[PowerBI87]

Thank you very much!