Tables

Tables

Working with Table visuals in Power BI

When to use

Table visuals are useful when you want to show tabular data, and don’t want to see it aggregated in any way

Instructions

Creating Table Visuals

• Select the Table visual
• Drag the fields you want to display into the Columns area of the visual
• Note that any field or measure can be used in the Columns area

Formatting

• Dragging multiple fields into the Columns area will render side-by-side columns of data
• Visual formatting can be done for the Formatting icon in the Visualizations pane

Hints & tips

• Format your measures (on the Measure Tools tab) as you’d like them to show in your Table. While the Table won’t let you declare a specific number format, most other visuals will.
• Start your formatting by choosing the closest style to what you want, then further customize via the other options
• The Condensed Style takes up the least room on the visualization canvas
• Tables cannot show subtotals - if you need a subtotal, change your visual to a Matrix instead