Forum Discussion
Calculated column being cleared when loaded to powerbi.com
I have a calculated field that comprises of the town a property is in with ", England" appended to the end to enable me to map the number of properties in each town on a Map. This was working fin...
v-haibl-msft
Microsoft Employee
Microsoft EmployeeAnonymous
You can export some data to Excel and share it with some online services like OneDrive, GoogleDrive and DropBox…
Then we can have a try to see if we can repro the same issue with these sample data.
Best Regards,
Herbert
My suspicion is that it is something to do with the expansion of the Centre field that works in the Desktop but not in the Service. However here is the data:
https://1drv.ms/f/s!Alva4sD0NJcXlnWzTYdbnMLdMKZG
The Centre, CityOrTown and City fields are all marked as Category "City".