Pivot chart control is used to visualize business intelligence data (buried in OLAP cube) and relational data. This interactive control with drill-down capabilities allows you to surface big-picture data and makes it available with different chart types.
Pivot chart control enables you to retrieve data from SSAS and relational data sources.
Pivot chart control allows users to visualize OLAP and relational data using different chart types: stacked area, spline area, step line area, stacked bar, 100% stacked bar, stacked column, 100% stacked column, spline, step line, pie charts, and scatter charts.
Pivot chart delivers a detailed view of any selected level member while drilling down and shows an abstract view after drilling up via expanders.
!Drill up/drill down functionality in UWP pivot chart control](images/pivotchart/PivotChartdrilled.png)
KPI is a collection of calculations associated with a measure group that evaluates business success.
Named sets are a multidimensional expression (MDX) that returns a set of dimension members, which can be created by combining cube data, arithmetic operators, numbers, and functions.
Users can take a close-up look at a data point plotted in the series at run time by zooming. Also, users can click and drag the zoomed chart to navigate to the data points for a better view through panning.