Two important metadata properties to configure for any column that will be visible on the Power BI report canvas are the data format and data category. The data formats should be consistent across data types and efficiently convey the appropriate level of detail. Data categories serve to enhance the data exploration experience by providing Power BI with information to guide its visualizations.
In this recipe, we set the data formats for dimension columns and measures. Additionally, geographical data category values are assigned to location columns to aid the visualization of this data.
