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,

 

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

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

v-jiascu-msft i created an excel file with 2 row with 2 columns in and formatted it as table, it was dummy data and saved it that is excel 2016, not to sure if the sharing will resolved this,  because it was really simple nothing complicated.   if you send me your email i can send it to you thank you :)

 

 

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

    Hi vanessafvg,

     

    I'm afraid this is a limitation for now. I would suggest you try to use the PBI Desktop as a workaround. 

     

     

    Best Regards,
    Dale

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

    Hi vanessafvg,

     

    I totally agree with you. As we can see from the image of my first post, it works. Please check your Messages box for my email. 

     

    Best Regards,
    Dale

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

    Hi vanessafvg,

     

    I have reported this issue to the Product Team: CRI 95832755. I will update the progress here. Actually, the single $ would work, which is the second option in the list of Symbol. 

     

    Best Regards,
    Dale

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

    not an option due to being a mac but thanks v-jiascu-msft