Formats and custom formats in Power BI (percent, currencies, thousands separator, decimals…)
Numbers formatting in Power BI – how numbers look in visuals.
Btw, this is something very different from data types. When formatting is about look, data types is about logic and storing in data model.
Formats are mostly related to decimal numbers, showing of currencies, thousands separators, percents…
How to change it?
On the right site click on the column or measure and then set it.
How to set the custom format? It has to be done somewhere else. Click on Model:
But there is something related to format, that has to be defined somewhere else. If you want Power BI not to “round” the big numbers (10M instead of 10 000 000), go to formatting of specific visual: