Display data in matrix Visual like tabular format

[venug20]

Hi Every one,

I have raw data like below

Row Labels	Sub-Category	Sum of Sales
Furniture	Bookcases	1522871.988
Furniture	Chairs	1681154.762
Furniture	Furnishings	442367.4739
Furniture	Tables	878768.6674
Office Supplies	Appliances	1080041.552
Office Supplies	Art	386915.9419
Office Supplies	Binders	584382.8757
Office Supplies	Envelopes	179012.7656
Office Supplies	Fasteners	85060.0439
Office Supplies	Labels	80092.486
Office Supplies	Paper	292648.3314
Office Supplies	Storage	1255552.179
Office Supplies	Supplies	273401.2066
Technology	Accessories	851079.1045
Technology	Copiers	1621935.071
Technology	Machines	878511.6281
Technology	Phones	1891126.685
Grand Total		13984922.76

and i want to show data in power bi like below...

Row Labels	Sub-Category	Sum of Sales
Furniture	Bookcases	1522871.988
	Chairs	1681154.762
	Furnishings	442367.4739
	Tables	878768.6674
Office Supplies	Appliances	1080041.552
	Art	386915.9419
	Binders	584382.8757
	Envelopes	179012.7656
	Fasteners	85060.0439
	Labels	80092.486
	Paper	292648.3314
	Storage	1255552.179
	Supplies	273401.2066
Technology	Accessories	851079.1045
	Copiers	1621935.071
	Machines	878511.6281
	Phones	1891126.685
Grand Total		13984922.76

Can anyone help on this...

Thanks in advance....

Regards

Venu

[Anonymous]

SImilar to the original question, I have a matrix control showing like this with the name in the rows on the left

Name	Sales	Purchases	Total
Multi Manager	500	200	700
High Income Growth	300	400	700
Growth & Income	100	300	400
Next Generation	300	300	600

I would like to flip the table by transposing the matrix so that the name in the rows above are now shown in the columnss at the top and the numbers go across instead of downwards like in the table below.

Name	Multi Manager	High Income Growth	Growth & Income	Next Generation
Sales	500	300	100	300
Purchases	200	400	300	300
Total	700	700	400	600

[Thejeswar · Accepted solution]

Hi @venug20,

Do the following to achieve what you want

1. Add both Row Labels and Sub-Category to Rows and Expand

Matrix with Rows Expanded

2. Switch off the Stepped Layout option as shown in the pic below 

Switch off stepped layout

3.  Modify the Row Subtotals as shown below

Modify the Row SubtotalsYour Output will look like the one below

[djbradp1]

Additonal Solution: If you want to repeat column 1 values then just create the table in matrix, turn off stepped layout,  THEN --> select the matrix and change the visualization type to "Table".  

[prihana]

Add both Type and description under Rows. Click on at the lowest level of data to expand it (grouping by Type)

[venug20]

Hi Prihana,

thanks for respond my post,

I have already tried, which has provided solution like below... this is known format.... i am asking like above format....

Pls help any one on my issue....

thanks in advance....