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 into a string, so I can not show it in some Power BI graphics.
Anyone with a solution? Thanks!
7 Comments
Hi dblanco,
In Power BI desktop, you can select this column, enable the Thousands Separator and set Decimal places as 2.
Best Regards,
Qiuyun YuThank 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.
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
Hi dblanco,
PG team are working on this issue. Will update once I get new information.
Best Regards,
Qiuyun YuThank you very much v-qiuyu-msft!
I'll be waiting for any answer.
Hi
you can write directly the format you want in the format field of that column, enter, and it will work 🙂
