Data formats

  1. Select the Data view--the icon between the Report and Relationships views
    • If the model is in the DirectQuery mode, these settings are available on the Modeling tab of the Report view
  2. Use the Fields list on the right to navigate the tables and select the column to format
  3. When selected, the Modeling tab will expose a Format dropdown that is contextually based on the data type:
Column Formatting
  1. Repeat this process by selecting the measures in the Fields list and setting the appropriate format:
Measure Formatting
  • These settings can also be accessed from the Modeling tab of the Report view
Formatting decisions should consider the impact of precision on visualizations. Fewer decimal places and more abbreviated date formats consume less space in reports and are easier to visually comprehend in dashboards.
上一章目录下一章