Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Pucca121
Helper II
Helper II

"Don't Summarize"

examplereturnrate.PNGreturnrate.PNG

 

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.

1 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. Smiley Happy

 

Regards

View solution in original post

7 REPLIES 7
Anonymous
Not applicable

Hi @Pucca121

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

Then it should work.

Captureww.PNG

 

Hello @Anonymous, 

 

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

Thanks 🙂

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 summarizeSmiley Happy

 

summarize1.PNG

 

Regards

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.

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. Smiley Happy

 

Regards

Thanks !!

 

P.

Anonymous
Not applicable

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

Can you provide a pic of the data?

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!