Forum Discussion

Justair07's avatar
Justair07
Icon for Resolver I rankResolver I
7 years ago
Solved

Do Not Aggregate Column Chart

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...
  • Justair07's avatar
    Justair07
    7 years ago

    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!

v-piga-msft's avatar
v-piga-msft
Icon for Resident Rockstar rankResident Rockstar
7 years ago

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's avatar
    Justair07
    Icon for Resolver I rankResolver I
    7 years ago

    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!