How do I repeat row values in a matrix?

[Anonymous]

This seems like a simple formatting issue, but I don't see any options to make it happen.

I have a matrix with three categories in Rows, dates going across in Columns, and values going down. 

The problem is, when I expand all my categories across the matrix, I just get a single instance of each category level, without repeating values. The problem is, when I export the data, I want it to look like a table, with repeated values.

In other words, right now it looks like this:

Category 1	Category 2	Category 3	1-Jan	2-Jan	3-Jan
Food	Fruit	Apples	2	1	2
		Oranges	4	7	6
		Bananas	9	5	2
	Vegetables	Celery	8	9	5
		Carrotts	6	2	6
Non-Food	Paper	Toilet Paper	3	2	1
		Paper Towels	7	8	4

And I want it to look like this:

Category 1	Category 2	Category 3	1-Jan	2-Jan	3-Jan
Food	Fruit	Apples	2	1	2
Food	Fruit	Oranges	4	7	6
Food	Fruit	Bananas	9	5	2
Food	Vegetables	Celery	8	9	5
Food	Vegetables	Carrotts	6	2	6
Non-Food	Paper	Toilet Paper	3	2	1
Non-Food	Paper	Paper Towels	7	8	4

Anyone know how to make this happen?

[Anonymous]

I have data as below 

and the expected output is 

I was able to achieve 

but for the groups values are not being repeated. Appreciate any help on this.

[SkorBI]

Seems like you want to change the stepped layout under options of row headers options.

[dilipkumar]

i had the same issue. there is awork around. in you dataset, just have an other column of INT and is unique to category3 . something like serial number for your category3 columne. use this column in rowgrouping  at the highest level  you will see the repeated data. 

eg.

1  fruit  apple

2  fruit  orange

3  veg   carrots

[jimbob2285]

Hi

I know this is an old post now and i still can't believe this is not a standard feature of a Matrix yet... But what do you mean by Row Grouping, i can't get the concept of an idex for category three, how would that help?

Thanks

[v-yuezhe-msft · Accepted solution]

@Anonymous,

In Matrix visual, repeated values will be grouped and hided automatically, there is no method to expand your categories across the matrix.

Regards,
Lydia

[Anonymous]

Hi, @v-yuezhe-msft : is this issue still there ? or any solution. 

[Anonymous]

Alternatively, You can start with lowest level of grouping as row 1 and highest as row n, that will fall in line with no breaks.