How to change my value measure type, need Kg and Tons.

[PiotrBZMZ]

Soo i've got a number like this.

8386178

And I need to show it as Tons, so it would look like this.

8 386,178 Tons

Or like this, 2 numbers after the comma.

8 386,18 Tons

Is there a way to do it?

[Icey · Accepted solution]

Hi @PiotrBZMZ ,

Can this meet your requirements?

Best Regards,

Icey

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

[Icey]

Hi @PiotrBZMZ ,

Can this meet your requirements?

Best Regards,

Icey

[amitchandak]

@PiotrBZMZ ,

Try this under the format option in Data Model views property pane 

### ###,### Tones

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-custom-format-strings

Or use format

format([Number],"### ###,###" )

[PiotrBZMZ]

@amitchandak 

Thanks to that solution i've manged to do 8 386 178 Kg. Can I now change it to 8 386,178 Tones?