cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

How do I repeat row values in a matrix?

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 1Category 2Category 31-Jan2-Jan3-Jan
FoodFruitApples212
  Oranges476
  Bananas952
 VegetablesCelery895
  Carrotts626
Non-FoodPaperToilet Paper321
  Paper Towels784

 

And I want it to look like this:

Category 1Category 2Category 31-Jan2-Jan3-Jan
FoodFruitApples212
FoodFruitOranges476
FoodFruitBananas952
FoodVegetablesCelery895
FoodVegetablesCarrotts626
Non-FoodPaperToilet Paper321
Non-FoodPaperPaper Towels784

 

Anyone know how to make this happen?

1 ACCEPTED SOLUTION
v-yuezhe-msft
Microsoft
Microsoft

@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

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

View solution in original post

4 REPLIES 4
dilipkumar
Frequent Visitor

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

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
Microsoft
Microsoft

@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

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

View solution in original post

Anonymous
Not applicable

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.

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!