Decimal Format

[dblanco]

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!

[v-qiuyu-msft]

Hi @dblanco,

In Power BI desktop, you can select this column, enable the Thousands Separator and set Decimal places as 2. 

Best Regards,
Qiuyun Yu

[dblanco]

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-msft]

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

[dblanco]

Thanks @v-qiuyu-msft,

So this is a problem that is in process to be solved?

[v-qiuyu-msft]

Hi @dblanco,

PG team are working on this issue. Will update once I get new information. 

Best Regards,
Qiuyun Yu

[dblanco]

Thank you very much @v-qiuyu-msft!

I'll be waiting for any answer.

[NedelinaTasheva]

Hi 

you can write directly the format you want in the format field of that column, enter, and it will work 🙂