Maklum balas Edit

Using the Field list in Power BI Desktop

  • Artikel
  • 3 minit untuk dibaca

The Field lists are being unified across Model view, Data view and Report view in Power BI Desktop. Unifying these views will create consistency for functionality and the user interface (UI) across views, and addresses customer feedback.

Changes you’ll notice across views include the following:

  • Iconography
  • Search functionality
  • Context menu items
  • Similar drag-drop behavior
  • Tooltips
  • Accessibility improvements

The intent is to improve Power BI Desktop usability. The changes should have minimal impact on your typical data workflow.

Field list changes

The following tables show the field list updates.

Original field list (Model view) New field list (Model view)
Original New
Icons and UI
original field list new field list
Context menu - Field
original context menu for Field new context menu for Field
Context menu - Table
original context menu for table new context menu for table
Tooltips
original tooltip new tooltip

Field list icons

There are new Field list icons as well. The following table shows the original icons and their new equivalent, and provides a brief description of each.

Original icon New icon Description
original folder icon new folder icon Folder in the Fields list
original numeric field icon new numeric field icon Numeric field: Numeric fields are aggregates that can be summed or averaged, for example. Aggregates are imported with the data and defined in the data model your report is based on. For more information, see Aggregates in Power BI reports.
original calculated column icon new calculated column icon Calculated column with a non-numeric data type: A new non-numeric column you create with a Data Analysis Expressions (DAX) formula that defines the column’s values. Read more about calculated columns.
original numeric calculated column icon new numeric calculated column icon Numeric calculated column: A new column you create with a Data Analysis Expressions (DAX) formula that defines the column’s values. Read more about calculated columns.
original measure icon new measure icon Measure: A measure has its own hard-coded formula. Report viewers can’t change the calculation, for example, if it’s a sum, it can only be a sum. The values aren't stored in a column. They're calculated on the fly, depending solely on their location in a visual. For more information, read Understanding measures.
original measure group icon new measure group icon Measure group.
original kpi icon new kpi icon KPI: A visual cue that communicates the amount of progress made toward a measurable goal. Read more about Key Performance Indicator (KPI) visuals.
original hierarcy of fields icon new hierarcy of fields icon Hierarchy of fields: Select the arrow to see the fields that make up the hierarchy. Watch this Power BI video on YouTube about Creating and working with hierarchies for more information.
original geo data icon new geo data icon Geo data: These location fields can be used to create map visualizations.
original identity field icon new identity field icon Identity field: Fields with this icon are unique fields, set to show all values, even if they have duplicates. For example, your data might have records for two different people named 'Robin Smith', and each will be treated as unique. They won't be summed.
original parameter icon new parameter icon Parameter: Set parameters to make parts of your reports and data models (such as a query filter, a data source reference, a measure definition, etc.) depend on one or more parameter values. See this Power BI blog post about query parameters for more information.
original calendar date field icon new calendar date field icon Calendar date field with a built-in date table.
original calculated table icon new calculated table icon Calculated table: A table created with a Data Analysis Expressions (DAX) formula based on data already loaded into the model. These are best used for intermediate calculations and you want to store as part of the model.
original warning icon new warning icon Warning: A calculated field with an error. For example, the syntax of the DAX expression might be incorrect.
original group icon new group icon Group: Values in this column are based on grouping values from another column, by using the groups and bins feature. You can read how to Use grouping and binning.
no original icon new change detection measure icon Change detection measure: When you configure a page for automatic page refresh, you can configure a change detection measure that is queried to determine if the rest of a page’s visuals should be updated.

Next steps

You might also be interested in the following articles: