Microsoft Power BI Cookbook

Configure model metadata

1. Add hierarchies such as Product Category, Product Subcategory, and Product Name and a Date hierarchy.
2. Set the Default Summarization and Sorting of Columns such as Month Name sorted by Month Number.
3. Assign Data Categories to columns such as Address or Postal Code to support geographical visualization.
4. Hide columns from the fact tables such that only measure groups are visible
   • If it's necessary to expose a column from the fact table, consider a dedicated measure table and associate the Home table of related measures to this table.

Details on all primary metadata settings are included in this chapter in recipes, Assigning data formatting and categories, Configuring default summarization and sorting, Setting the ...