Value formatting

[Dond]

Hi!!!

I'm connecting to an API and when it brings the column of values ​​it comes like this

even changing to Decimal/en-US is not in the correct format, even customizing the values ​​are not the way I want, even putting them as currency.

It was right to stay like this
12350 --> R$123,50

106480 --->R$1,064.80

13853 ---> R$138,53

[Anonymous · Accepted solution]

Hi @Dond ,

Please have a try.

Create a column.

Column = [Column1]/100

Then format the column.

#,##0.#0

Best Regards
Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Dond]

Thanks a lot, that's exactly what I was looking for. Big hug!

[Anonymous]

Hi @Dond ,

You can change the column.

Or you can use format dax.

Column = FORMAT('Table (2)'[Column1],"R$#,##0.##")

How to Get Your Question Answered Quickly 

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards
Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Dond]

Thanks for your answer.

That's the problem

106,480 is to stay in the 1,064.80 format

12,350 is to stay in the 123.50 format