Dimension tables

The columns of dimension tables give the measures from the fact tables context, such as Internet Net Sales by sales territory country and calendar year. More advanced dimension columns, such as the Customer History Segment column, described in Chapter 2, Connecting to Sources and Transforming Data with M, can instantly give report visualizations meaning and insight. In addition to their application within report visuals, such as the date axis of charts, dimension columns are frequently used to set the filter conditions of a report, a report page, or a specific visual of a report page. By default, Power BI lists dimension tables alphabetically in the fields list and also lists column names of tables alphabetically.

Just as ...

Get Mastering Microsoft Power BI now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.