Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi everyone,
Need a little help on this
When we are presenting data(say for e.g:Name,Marks) in matrix,it is getting grouped by Name like:
But we need Name in each row like:
Please can you let me know how to ungroup Name.
Any help is much appreciated.
Thanks,
Saranee
Try using a "Table" visual, instead of a "Matrix" visual, and ensure any subsequent columns are set to "Don't Summarize".
Although, based on your sample screenshots, it's a little unclear as to what your data actually looks like, and what you're actually trying to show.
Thanks for your reply.But we can not use table visualization in this case.Name column is unsummarized only.
Please let me know if we can implement this thing keeping matrix as visualization.
Thanks,
Saranee
@saranee,
How do you store data in your original table? If your original table looks like below, you can only use table visual to get expected result. In Matrix visual, the marks are automatically summarized for each name.
Regards,
Lydia
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
117 | |
101 | |
71 | |
61 |