Forum Discussion

AliceTran1643's avatar
AliceTran1643
Frequent Visitor
8 months ago
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. ...
Need Help
  • AliceTran1643's avatar
    AliceTran1643
    8 months ago

    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.

AliceTran1643's avatar
AliceTran1643
Frequent Visitor
8 months ago

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.

Anand24's avatar
Anand24
Super User
8 months ago

AliceTran1643,
To be honest, aggregation has nothing to do with other fields (Particle Type in your case) of the visual but happy that your issue is resolved !