Forum Discussion
Stop Data Aggregation on a Matrix
MasonMA Funny enough. As I am making a sample file to upload, that sample file was able to show the raw data that I wanted. I am guessing since I use the exact same "Particle Type" field in another query instead of the raw data query, it confuses Power BI somehow. Once I use the "Particle Type" field of the raw data query, its working.
Hi AliceTran1643,
You can choose "Don't Summarize" from the fields taken in visualization.
Another observation - If you take the summarized field first in the table/matrix and then format the column to Don't summarize like you did in screenshot, it will still keep the aggregation. In that case, you need to remove the field and add it again. Basically, format the field forst and then take it into the visual.
Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!! Proud To Be a Super User !!! |
Anand24 I did format the field first before adding it into the Matrix. The 2nd screenshot is showing that. I do not have the option i choose "don't summarize" for the column itself. See below.
Also, I tried moving the field to rows and this is what it turns out which is not what I'm looking for.