A table is a grid that contains related data in a logical series of rows and columns. A table can also contain headers and a row for totals. Tables work well with quantitative comparisons where you're looking at many values for a single category. In the following example, the table displays five different measures for the Category items, including average prices, year over year sales, and sales goals. Power BI helps you create tables in reports and cross-highlight elements within the table with other visuals on the same report page. You can select rows, columns, and even individual cells, then cross-highlight the values. You can also copy and paste individual cells and multiple cell selections into other applications. When to use a table Tables are a great choice for several scenarios: Representing numerical data by category with multiple measures. Displaying data as a matrix or in a tabular format with rows and columns. Reviewing and comparing...
Deep dive into visual calculations: Adding calculations directly to your Power BI visuals (Generally Available)
With visual calculations (Generally Available), you can write DAX directly on a visual to calculate exactly what you need to show. They're useful when a calculation is specific to a single visual, so you can define the logic right where you need it instead of adding a model or report measure. Figure: Create a visual calculation directly on a Power BI visual. Custom totals for tables and matrices are also generally available. Custom totals are powered by visual calculations and give you a simple way to adjust the total row to fit your reporting needs. Figure: Customize totals for table and matrix columns using built-in aggregation options. How visual calculations work A visual calculation is a DAX calculation directly on a visual. Because the calculation runs against the aggregated data already on the visual, the DAX is often simpler than the equivalent measure, and you don't need to manage filter context across the whole model. To add a visual calculation, se...