Table visual exceptions

In this example, a report is designed to identify and analyze transactions that negatively impact the margin.

  1. Identify the dimension columns and add them to the canvas as a table visual.
  2. Add the measures to the table including Sales Amount and Margin %.
  3. Apply a visual level filter to the Sales Amount such that each row represents a significant transaction or grouping.
Visual Level Filter Applied to Measure
  1. Turn the Totals off from the formatting pane given the filter condition applied to the visual.
  1. Apply a Table style such as Alternating Rows or use the Values and Column headers options to apply a standard format. ...

Get Microsoft Power BI Cookbook now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.