Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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:
StudentID | StudentName | Teacher | Subject | Month | Grade |
1A2 | John | Joe | Math | Jan | 90% |
1A2 | John | Joe | Math | Feb | 81% |
1A2 | John | Joe | Math | Mar | 91% |
1A2 | John | Jessica | English | Jan | 95% |
1A2 | John | Jessica | English | Feb | 95% |
1A2 | John | Jessica | English | Mar | 89% |
2B2 | Peter | Sparkle | Science | Jan | 68% |
2B2 | Peter | Sparkle | Science | Feb | 72% |
2B2 | Peter | Sparkle | Science | Mar | 78% |
5C2 | Gary | Coby | Art | Jan | 100% |
5C2 | Gary | Coby | Art | Feb | 100% |
5C2 | Gary | Coby | Art | Mar | 96% |
5C2 | Gary | Baugh | History | Jan | 59% |
5C2 | Gary | Baugh | History | Feb | 76% |
5C2 | Gary | Baugh | History | Mar | 74% |
5C2 | Gary | Joe | Math | Jan | 99% |
5C2 | Gary | Joe | Math | Feb | 96% |
5C2 | Gary | Joe | Math | Mar | 91% |
10Y6 | Kyle | Errol | Geography | Jan | 88% |
10Y6 | Kyle | Errol | Geography | Feb | 90% |
10Y6 | Kyle | Errol | Geography | Mar | 97% |
visualization I want to achieve
StudentID | StudentName | Subject | Teacher | Jan | Feb | Mar |
1A2 | John | Math | Joe | 90% | 81% | 91% |
1A2 | John | English | Jessica | 95% | 95% | 89% |
2B2 | Peter | Science | Sparkle | 68% | 72% | 78% |
5C2 | Gary | Art | Coby | 100% | 100% | 96% |
5C2 | Gary | History | Baugh | 59% | 76% | 74% |
5C2 | Gary | Math | Joe | 99% | 96% | 91% |
10Y6 | Kyle | Geography | Errol | 88% | 90% | 97% |
Solved! Go to Solution.
Hey @Sagejah9 ,
transforming a matrix visual that looks like this:
with its nested row headers
into something that looks like this:
Mark the matrix visual and then change the formatting of the matrix visual:
Hopefully, this is what you are looking for.
Regards,
Tom
Hey @Sagejah9 ,
transforming a matrix visual that looks like this:
with its nested row headers
into something that looks like this:
Mark the matrix visual and then change the formatting of the matrix visual:
Hopefully, this is what you are looking for.
Regards,
Tom
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |