Formatting Measure

[Anonymous]

Hi guys,

i want to format my measures to the format of XXX Mio. As seen in the screenshot this is done in the left column. The two measure right next to it give me the full million value. 

This is my measure:

I tried probably every formatting option from the ribbon but i will always show the full million value. 

I know there is a way to do it with FORMAT but that will change the value to text i guess. In worst case i would take that option but isnt there another option to do in a way so the format stays a number?

Thanks!

[v-yingjl]

Hi @Anonymous ,

"I know there is a way to do it with FORMAT but that will change the value to text i guess. In worst case i would take that option but isnt there another option to do in a way so the format stays a number?"

As far as I know, I'm afraid not. The number type is strictly defined in power bi, if there is any other value which combines with numbers, the data type will always be changed to text.

So although currenly using FORMAT function is the 'worst' method, it is also the only inevitable method.

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Anbody another idea?

[amitchandak]

@Anonymous , see if this UI can help

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

[Anonymous]

This only works for columns. I have a measure though