Column returns sum value rather than individual records

[Anonymous]

Hi 

I have excel spread sheet in which i have three columns with data as shown below. 

Airport ID is the unique. However, when i load the data into PowerBI the Airport ID field returns as a cummulative value rather than individual records. 

The field adds individual value from each row and displays the cummulative value. how do i change it to display individual records ?

[Kristjan76 · Accepted solution]

You can mark the default behaviour of the column not apply aggregation.

Select the column, go to the Modeling tab. In the Properties section you should see "Default Summarization". You could also click the arrow in the individual visual (next to the name of the column Airport ID) and there you can select not to summerize.

Regards,

Kristjan

[themistoklis · Accepted solution]

@Anonymous

See following image:

[Kristjan76 · Accepted solution]

You can mark the default behaviour of the column not apply aggregation.

Select the column, go to the Modeling tab. In the Properties section you should see "Default Summarization". You could also click the arrow in the individual visual (next to the name of the column Airport ID) and there you can select not to summerize.

Regards,

Kristjan