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
Creating Table Visuals
- Select the Table visual
- Drag the fields you want to display into the Values area of the visual
- Note that Text fields can be used in the Values area
- Dragging multiple fields into the Values area will render side by side columns of data
- Visual formatting can be done via the fields under the paint roller in the Visualizations area
Hints & tips
- Format your measures (on the Modeling 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 Matrix style to what you want, then further customize via the other options.
- The Condensed Matrix Style takes up the least room on the visualization canvas.
- Tables cannot show subtotals. If you need a subtotal, change your visual to be a Matrix instead.
Lesson notes are only available for subscribers.