Number column not transforming to Power bi properly

[mangeski]

Hey team,

I have a MS list with a number column called "Score" that I'm attempting to transform over to Power BI. When I pull the data over, it shows up as an equation instead of a column. As a result, im unable to change the data its presenting to the correct data. Example, the number column from MS list represents a total score in each submission.  Below is the list showing 7 submissions from room 183 but different scores for each. Power BI is showing 7 from room 183 and not individual scores of each submission. Any help would be greatly appreciated.

[anilelmastasi · Accepted solution]

Hello  , 

For this you should disable automatic summarization. In the fields pane slect the score column. 

Under column tools -> Defult summarization, change it from Count to Don't summarize.

 

If this solved your issue, please mark it as the accepted solution. ✅

@mangeski

[mangeski]

Thank you both for your response. This was part of my issue and from there i was able to figure out i needed to develop my visuals better to capture what I was wanting to express. I selected @anilelmastasi solution due to using that visual. Both gave the correct advice but i wasnt able to do that approach from @AmiraBedh 's visual. Thanks again.

[anilelmastasi]

Hello @mangeski ,

Thank you for accepting as solution. I want you give a quick tip, as a a best practice you should select all columns as "Don't summarize" and write explicit measure for aggregations etc.

Also Amira's answer is correct too. In "visualizations" pane, right click the auto aggregated column and you are able to see don't summarize option too. But it just works for that visual, not all visuals. To make it general, you can use my answer.

[AmiraBedh · Accepted solution]

Hello !

Thank you for posting on Microsoft Fabric community.

I think what you are showing is the count of the rows for each room number and not the score it self.

In your visual try to check the following you may need to go for don't summarize or crate a measure if needed.

[anilelmastasi · Accepted solution]

Hello  , 

For this you should disable automatic summarization. In the fields pane slect the score column. 

Under column tools -> Defult summarization, change it from Count to Don't summarize.

 

If this solved your issue, please mark it as the accepted solution. ✅

@mangeski