Forum Discussion

PowerBI87's avatar
PowerBI87
Frequent Visitor
6 years ago
Solved

New user - simple request

Hi all,

 

I have some data and created a table:

 

CompanyBundleYear
XYZ CORPBronze2021
ABC CORPSilver2019
GHI CORPGold2018
LMN CORPGold2019
XYZ CORPSilver2019
XYZ CORPSilver2020

 

 

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

 

CompanyBundleYear
XXZ CorpBronze2021
 Silver2019
 Silver2020
ABC CORPSilver2019
GHI CORPGold2018
LMN CORPGold2019

 

Any adivise would be apprecitated.

 

Thanks.

 

 

Need Help
  • v-alq-msft's avatar
    v-alq-msft
    6 years ago

    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.

     

2 Replies

  • v-alq-msft's avatar
    v-alq-msft
    Community Support
    6 years ago

    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.