"Don't Summarize"

[Pucca121]

Hello!

When I put this calculated column in a visual, PowerBi sum the colum. I would like to see each row, not the sum. How can I do this?

Thank you!

P.

[Anonymous]

Hi @Pucca121

It looks as you missed to put a value in the Axis.

Then it should work.

[Pucca121]

Hello @Anonymous, 

I put this for the visual. Isn't it correct?

Thanks 🙂

[v-ljerr-msft]

Hi @Pucca121,

In Power BI Desktop, we can select the Default Summarization icon under Modeling tab to change how a field is summarized.

In your scenario, just select sword_Codeaction column, then click the Default Summarization icon under Modeling tab, and select Don't summarize. 

Regards

[Pucca121]

Hello @v-ljerr-msft,

Thank you for your help.

However, two things.

1. With the measures, I can't change the default summarization. But, in my case, the default summarization is already on "don't summarize"

2. I check my measures and my data, all is correct. When I put my measures in a table, all works perfectly, but when put it in a a column chart, it doesn't work.. Is it because the fact they are measures?

Thank you very much

P.

[v-ljerr-msft · Accepted solution]

Hi @Pucca121,

Yes, you need to use a column not a measure for the Shared Axis of the chart, or it will return a single column/point on the visual. 

Regards

[Pucca121]

Thanks !!

P.

[Anonymous]

mhhh, it's hard to guess without seeing the data.

Can you provide a pic of the data?