Forum Discussion
Formatting Measure
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. ...
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.