Forum Discussion
Remove summarization of Matrix Values
Hello,
I'm trying to create a Matrix table that maps a user's answer score to a question for multiple users. In my database I have the questions, user identifiers and their answer scores for the question.
Using the Matrix visual, I'm able to get everything to show correctly apart from the actual answer score values, like this:
I need the score values to be displayed as they are in the database, with no summarization. However it appears that there is no option to select 'do not summarize' for the values in the Matrix visual as there is in other visuals (such as a regular Table):
The issue with this is it is enforcing some sort of calcualtion on the answer scores (sum, count, average etc.) which means they're not accurate. Is there any way to disable summarization?
Thanks in advance
4 Replies
Hello purplehaze,
If you attached an image its not available, now if you are using direct mode. I recommend you to check your data type your source If this one it's numeric that's the reason your data is being aggregated.
Regards!
ED
Hi edejes2
Thanks for your reply, I added the images to my public album and added them - can see them this end so probably user error somewhere...
Data is being imported rather than DirectQuery if that's what you're referring to?
The behaviour I'm seeing is with the data type set to whole number for data type and format. I've got the category set to Uncategorized and I've set the Default Summarization to 'Don't summarize'. With these settings, there's no don't summarize option. I've had a play with other datatypes etc and all seem to enforce summarization on the Matrix table values field.
Thanks,
PH
