Forum Discussion
Column returns sum value rather than individual records
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 ?
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
Anonymous
See following image:
2 Replies
- themistoklis
Community Champion
Anonymous
See following image:
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