Forum Discussion
Value formatting
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
Hi Dond ,
Please have a try.
Create a column.
Column = [Column1]/100Then format the column.
#,##0.#0Best Regards
Community Support Team _ PollyIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 Replies
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 _ PollyIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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
Hi Dond ,
Please have a try.
Create a column.
Column = [Column1]/100Then format the column.
#,##0.#0Best Regards
Community Support Team _ PollyIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks a lot, that's exactly what I was looking for. Big hug!
