Forum Discussion
Solved
Stop Data Aggregation on a Matrix
Hello, I've been trying to get my matrix to show actual data values but it keeps aggregating the data. I tried the "Don't Summarize" but it still didn't work. Below is an example of my 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 MasonMA,
This field is dragged into the visual and not a DAX measure. Also, I do not have the option to choose "don't summarize."
AliceTran1643 ,
You won't get the option of "Don't summarize" in matrix visual's value section. Pull that field into Rows section and then select Don't summarize. Refer to reply 8 of this thread.
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 !!! |