Forum Discussion
vanessafvg
7 years agoCommunity Champion
developing 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 tha...
henriquesilveir
7 years agoResolver 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:
- vanessafvg7 years agoCommunity Champion
henriquesilveir thanks for your response, but unfortunately not possible to do on a mac
- v-jiascu-msft7 years agoMicrosoft 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- vanessafvg7 years agoCommunity Champion
v-jiascu-msft yep i tried that but it didn't work ta