Hello, I am working with Power Bi Desktop and everything works fine, but I need to show decimals with this format "0,000.00". I found the FORMAT () function, but this function converts my number in...
dblanco
8 years agoRegular Visitor
Thank you for your response v-qiuyu-msft!
But what I need in my number is the format "0,000.00"
For example: 4,397,051.95
My number only show as "4.397.051,95"
I don't know how to do that, and the function FORMAT() return my number as string but I need as a decimal for some graphics in Power BI Desktop.
- v-qiuyu-msft8 years agoCommunity Support
Hi dblanco,
It's due to the number settings in Control Panel, please change the setting like below:
Then restart the Power BI desktop, when you go to the Data tab, you will see data is changed with desired format. But there is a known issue that the visual will not display with changed format, it's already reported internally: CRI 49845323. Will let you know if get any information.
Best Regards,
Qiuyun Yu