Depending on where the data for a table originated from, additional options for interacting with the data may exist.

Edit Parameters

  • Link the query parameters to Excel cells or slicers.

Edit Connection Range

  • Link the Connection String to a cell, allowing driving the server or database from other parameters in the workbook.

Breakout (available from measure columns)

  • Create a ranked list of the top or bottom values making up the number selected.