Forum Discussion
Solved
Sum Aggregate - Postal codes in map
Hello all, I please need your help: For visualising in a map I got postal codes from all over the world in an excel file - my problem is: it always sums up all the postal codes instead of usi...
- You change the data type within in power bi. Please refer to this link https://docs.microsoft.com/en-us/power-bi/desktop-data-types
Thanks for your help - still doesnt work unfortunately...
I set the postal code as a text in my excel file
Problem:
I cant select aggregates (tried like this: select column in dropdown - click on visualisation - there is no dropdown with aggregate options) - is this caused by the fact that I only got the free version of power bi?
danextian
Super User
Super UserYou change the data type within in power bi. Please refer to this link https://docs.microsoft.com/en-us/power-bi/desktop-data-types