Forum Discussion

vanessafvg's avatar
vanessafvg
Icon for Community Champion rankCommunity Champion
7 years ago

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...
Need Help
vanessafvg's avatar
vanessafvg
Icon for Community Champion rankCommunity Champion
7 years ago

henriquesilveir thanks for your response, but unfortunately not possible to do on a mac

v-jiascu-msft's avatar
v-jiascu-msft
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

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.

developing-a-report-in-power-bi-service-data-types

 

Best Regards,
Dale

  • vanessafvg's avatar
    vanessafvg
    Icon for Community Champion rankCommunity Champion
    7 years ago

    v-jiascu-msft yep i tried that but it didn't work ta

    • v-jiascu-msft's avatar
      v-jiascu-msft
      Icon for Microsoft Employee rankMicrosoft Employee
      7 years ago

      Hi vanessafvg,

       

      That's strange. Totally work in my side. I would suggest you create a support ticket here. Maybe something is wrong.

      create-ATicket

       

      Best Regards,
      Dale

      • vanessafvg's avatar
        vanessafvg
        Icon for Community Champion rankCommunity Champion
        7 years ago

        v-jiascu-msft definitely doesn't work, i just retried, works in neither the desktop nor serivce, it comes through as a whole number.  I need it to be currency - someone else tried it and didn't work for them either.