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.

MasonMA's avatar
MasonMA
Super User
8 months ago

This shouldn't be an odd issue from my instinct, but could you share .pbix or the sample file with only the related data and Matrix so that other users can have a look? 

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 !