Columns

In Power BI, columns refer to the individual fields or attributes within your dataset. These columns contain the actual data that you import or connect to in Power BI Desktop.

User Interface

1. Table Pane: The side expandable pane consists of all the tables in the data model.

The below attributes of columns are captured by Powerops:

1. Column Name: Name of the column in the selected table.

2. Display Folder: Container to show columns in a folder structure for easy organization.

3. Is Hidden?: (Yes/No) It clarifies whether a column is hidden or not.

4. Is Row Label?: The Row label field value is used so users can easily identify the row.

5. Is Key Column?: The Key column field value provides the unique ID for the row.

6. Data Type: Specifies what kind of information the column can hold, like text, numbers, dates, etc.

7. Sort By Column: Arranging rows of the column based on a specific condition and order.

8. Is Implicit Measure?: (True/False) Detects if automatically generated functions like SUM, COUNT, MIN, MAX are used

9. Summarize By: Displays the type of aggregation used (if any)

10. Is Nullable?: (Yes/No) It specifies if the column can be left empty, without a value.

11. Is Used?: (True/False) It specifies whether the specific column is used in the report or not

12. Format: Defines how data in a column is displayed.

13. Percentage Format: (Yes/No) Whether the column displays its values as percentages.

14. Thousand Separator: (Yes/No) Refers to the formatting option that adds commas or other symbols to separate thousands in numerical values

15. Decimal Places: Specifies the number of digits to show after the decimal point in numerical data.

16. Data Category: Type of information a column holds.

17. Description: It provides an explanation of the column's content.