[]
The Data Visualization settings control how categorical values and dimensions are displayed within a visualization. These options help you refine how data is grouped, highlighted, and represented—even in cases where certain categories have no underlying values. The two primary features in this section are Top N Grouping and Include All Dimensions.
Data Visualization properties apply to all notebook chart blocks except the Scatter Chart, the KPI Chart, the Pivot Table, the Data Table, the KPI Matrix, and the Label Slicer.
Top N Grouping allows you to focus your chart on the highest-performing categories by displaying only the top N results and consolidating all remaining categories into a single Other group. This makes it easier to compare your most significant values against the rest of the dataset without clutter or noise.
Once Top N Grouping is enabled, you can specify the number of top categories to display. The default is 3, but you can set any number based on your analysis needs.
This feature is particularly useful when you want to highlight leading contributors, show concentration of values, or simplify complex datasets by grouping long tails.
Here is an example of a column chart that displays Sales by Subcategory for the top three subcategories.

Include All Dimensions ensures that all dimension members appear in the visualization—even when no data values exist for them. When this option is enabled, categories without associated measures are still displayed on the axis, allowing the viewer to see the full range of possible dimension values rather than only those with data.
This is useful when you want to:
Show continuity across time periods
Display complete category ranges
Highlight missing or zero-value data explicitly
For example, in a Sales by Year column chart, the dataset may not contain values for 2021. When Include All Dimensions is enabled, the year 2021 still appears on the axis, even though no bar is plotted for that year.
