Forum Discussion
Community Championdeveloping a report in power bi service - data types?
is there a way of converting a data type in the service.
I sucked in an excel file into the data sets, but i want to convert the decimal to currency, is there a way to do this? The issue is that i have set the currency in excel but the service doesn't seem to be inheriting the currency, only the numerical format.
13 Replies
henriquesilveirResolver IV
yvanessafvg hello, is not possible!
You can only change the field type into power bi desktop.
My suggest: you could download a .pbix file in service, change it and republish.
Take a look how to do this below:
- vanessafvg
henriquesilveir thanks for your response, but unfortunately not possible to do on a mac
v-jiascu-msftMicrosoft Employee
Hi vanessafvg,
How did you format it in the Excel?
I did it by right-click the column and choose "Format Cells". The format seems still valid in the Service. Please refer to the snapshot below.
Best Regards,
Dale
- henriquesilveir
yvanessafvg hello, is not possible!
You can only change the field type into power bi desktop.
My suggest: you could download a .pbix file in service, change it and republish.
Take a look how to do this below:
