The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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
Solved! Go to 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.
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.
Thanks a lot, that's exactly what I was looking for. Big hug!
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.
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