Forum Discussion
How to create custom Data category?
Hello,
i want to create for Amount field DAta category which is curreny - but i have only option:
How to add this?
Best,
Jacek
Hi jaryszek, the "Data category" helps Power BI to understand how to interpret your data when you want to provide it an extra meaning. For example, you can tell Power BI that a text value is not simply a text, but a city, so it will try to associate it with cities when you use map visual. Similarly, with numeric values you can indicate whether the number is a latitude or longitude. The list of available values depend on the column data type.
Instead, a "currency" is not a data category, but a formatting option. The fact that Power BI knows that your numeric value is a currency won't in any way affect how Power BI should deal with values in a column: they are still numbers.
See image below to correctly format a numeric column as a currency:
Good luck! 🙂
3 Replies
jaryszek Currency is a Data type (Fixed decimal number) not a Data category.
Ok so data category is constant?
Best,
JacekHi jaryszek, the "Data category" helps Power BI to understand how to interpret your data when you want to provide it an extra meaning. For example, you can tell Power BI that a text value is not simply a text, but a city, so it will try to associate it with cities when you use map visual. Similarly, with numeric values you can indicate whether the number is a latitude or longitude. The list of available values depend on the column data type.
Instead, a "currency" is not a data category, but a formatting option. The fact that Power BI knows that your numeric value is a currency won't in any way affect how Power BI should deal with values in a column: they are still numbers.
See image below to correctly format a numeric column as a currency:
Good luck! 🙂
