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
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.

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

        Hi vanessafvg,

         

        Can you share the Excel file? Only a little piece is needed that can reproduce the issue. BTW, I have Excel 2016. The contents in Excel are formatted as a table.

         

        Best Regards,
        Dale