Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Sagejah9
Helper III
Helper III

Have row items repeat which represent grouping in a Matrix table

Hi , I am trying to build a table that looks like the below table. My dataset is unpivoted having the months in one column. I would use the Matrix visual to get the months as individual columns however the rows gets nested in each other forming hierarchy and I have to keep expanding the rows to see the other columns. How can I do this without using the regular table visual or pivoting my dataset

Dataset looks like this form:

StudentIDStudentNameTeacherSubjectMonthGrade
1A2JohnJoeMathJan90%
1A2JohnJoeMathFeb81%
1A2JohnJoeMathMar91%
1A2JohnJessicaEnglishJan95%
1A2JohnJessicaEnglishFeb95%
1A2JohnJessicaEnglishMar89%
2B2PeterSparkleScienceJan68%
2B2PeterSparkleScienceFeb72%
2B2PeterSparkleScienceMar78%
5C2GaryCobyArtJan100%
5C2GaryCobyArtFeb 100%
5C2GaryCobyArtMar96%
5C2GaryBaughHistoryJan59%
5C2GaryBaughHistoryFeb 76%
5C2GaryBaughHistoryMar74%
5C2GaryJoeMathJan99%
5C2GaryJoeMathFeb96%
5C2GaryJoeMathMar91%
10Y6KyleErrolGeographyJan88%
10Y6KyleErrolGeographyFeb90%
10Y6KyleErrolGeographyMar97%



 

visualization I want to achieve

StudentIDStudentName SubjectTeacherJanFebMar
1A2JohnMathJoe90%81%91%
1A2JohnEnglishJessica95%95%89%
2B2PeterScienceSparkle68%72%78%
5C2GaryArtCoby100%100%96%
5C2GaryHistoryBaugh59%76%74%
5C2GaryMathJoe99%96%91%
10Y6KyleGeographyErrol88%90%97%
1 ACCEPTED SOLUTION
TomMartens
Super User
Super User

Hey @Sagejah9 ,

transforming a matrix visual that looks like this:

image.png

with its nested row headers

image.png

into something that looks like this:

TomMartens_0-1635667670919.png

Mark the matrix visual and then change the formatting of the matrix visual:

  1. turn off the "Stepped layout" and the "+/- icons"options
    image.png
     
  2.  turn off the "Row subtotals"
    TomMartens_1-1635668120728.png

     

Hopefully, this is what you are looking for.

 

Regards,

Tom

 

 



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

View solution in original post

1 REPLY 1
TomMartens
Super User
Super User

Hey @Sagejah9 ,

transforming a matrix visual that looks like this:

image.png

with its nested row headers

image.png

into something that looks like this:

TomMartens_0-1635667670919.png

Mark the matrix visual and then change the formatting of the matrix visual:

  1. turn off the "Stepped layout" and the "+/- icons"options
    image.png
     
  2.  turn off the "Row subtotals"
    TomMartens_1-1635668120728.png

     

Hopefully, this is what you are looking for.

 

Regards,

Tom

 

 



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.