Tables display data in rows and columns making analysis simple and clear. In Power BI tables are commonly used to view detailed data and verify underlying values before applying advanced visualizations. Power BI Desktop can automatically create a table when fields are added but manually creating and customizing tables offers better control.
Creating a Table in Power BI
You can download dataset from here
1. Select the Table visual and drag the required fields into the Columns section to display the data in tabular form.
2. On the right side of the Power BI Desktop we can see the required columns to add to the report i.e. Date and High.
3. Drag Date and High into the Columns section. Power BI automatically breaks the DateTime field into Year, Quarter, Month and Day and shows the sum of High values for each date.
4. Under the Visualizations section click on the Table icon to add a table for these columns.
5. A table is created. We can notice that 4 different columns are created for Date and High shows the Sum as the default aggregate function used.
6. To change the aggregation click the drop-down arrow in the Columns section and select the required function such as Average.
7. We can also customize the Date column by simply removing the Month and Day. Now only Quarter and Year will be shown in the table.
8. We can see in the below image only the Year and Quarter are left.
9. The below image shows the table which contains three columns, Year, Quarter and Average of High.
