Do Not Aggregate Column Chart

[Justair07]

Hello everyone,

I'm brand new to Power BI and I'm attempting my first report/dashboard.

My column chart defaults to aggregate (summerize?) my data. I don't want it to do this. I want my value field (ScrapV) to show all individual records for my axis (Scrap Reason). I'm also applying a filter to show only valuse >= 100.

When I go to table view, and select "Don't Summerize" on my ScrapV value field, it shows exactly as I would expect in the table.

How can I do this same exact thing in a colmun chart?

Thank you,

- Justin

[v-piga-msft]

Hi @Justair07,

Normally, the value in chart will be the aggregate value. 

You could go to modeling tab and set the default summarization to be Don't summarize. 

If you still have the aggregate value in chart, I'm afraid that there is no ways for us to show the individual records in chart.

In addition, you could share some data sample and your desired output, may be we could have another way to solve it.

Best  Regards,

Cherry

[Justair07 · Accepted solution]

@v-piga-msft thank you for explaining. I was able to accomplish something close enough (maybe even better). I just had to stack the data to get individual records not summerized. I also had to add the applicable field to the Value and Legend. Very cool!