Change Data Blending in a Visualization

You can modify a visualization's properties to override the workbook's data blending settings.

Datasets that use Oracle Essbase or Oracle EPM Cloud connections aren't available for blending.

See Understand Blending.

1. On the Home page, hover over a workbook, click Actions, then select Open.
2. In the workbook, select a visualization, and in the Properties pane click Datasets.
   
   
3. To change the default blending, click Data Blending, and select either Auto or Custom.
   If you choose Custom, you can set the blending to either All Rows or Matching Rows.
   • You must assign at least one source to All Rows.
   • If both sources are All Rows, then the system assumes that the tables are purely dimensional.
   • You can’t assign both sources to Matching Rows.