Forum Discussion

v-xjiin-msft's avatar
v-xjiin-msft
Solution Sage
8 years ago

Hi Richard76,

 

Currently, all the built-in formats are listed in the Format option in Modeling pane. If there doesn't exist the format like £3000k, it means that we cannot achieve it with built-in ways.

 

So to achieve your requirement, we need some workarounds. We should first define an unit and manually format the original currency to your wanted format. Please refer to following calculated column:

 

Formatted amount =
IF (
    Amount[Amount] > 3000,
    "£" & DIVIDE ( Amount[Amount], 1000 )
        & "K",
    "£" & FORMAT ( Amount[Amount], "####" )
)

 

However, by doing this the new column will be displayed as text type no longer numbers. Because there's no such format in numbers column. If you still want to keep numbers column with your wanted format. I'm afraid currently it is not supported in Power BI desktop. And I would suggest you to submit an idea here for a feature request.

 

Thanks,
Xi Jin.