By Michele Hart
Thursday, April 27, 2017
A table is a grid that contains related data in a logical series of rows and columns. It may also contain headers and a row for totals. Tables work well with quantitative comparisons where you are looking at many values for a single category. For example, this table displays 5 different measures for Category.
Tables are a great choice:
to see and compare detailed data and exact values (instead of visual representations)
to display data in a tabular format
to display numerical data by categories
To follow along, sign in to Power BI and select Get Data > Samples > Retail Analysis Sample. We'll create the table pictured above to display sales values by item category.
Select Item > Category. Power BI automatically creates a table that lists all the categories.
Select Sales > Average Unit Price and Sales > Last Year Sales and Sales > This Year Sales and choose all 3 options (Value, Goal, Status).
In the Visualizations pane, locate the Values well and drag-and-drop the values until the order of your chart columns matches the first image on this page. Your Values well should look like this.
Pin the table to the dashboard by selecting the pin icon
Sometimes Power BI will truncate a column heading in a report and on a dashboard. To show the entire column name, hover over the space to the right of the heading to reveal the double arrows, select and drag.
More questions? Try the Power BI Community