KPI support

[ASIM TAUSIF KHAN]

Can you show me any example in which this control support KPI. lkin in the chart control we can see a chart with multi series chart. is it possible to use it in Pivot control

[AngelinFaithSheeba PaulvannanRajadurai]

Hi Asim,

Please find the response below.

Query	Comments
Can you show me any example in which this control support KPI.	We don’t have KPI columns support for pivot table with relational data source. However, using cellTemplate option, you can customize the pivot table cells based on your needs.   Please refer the below documentation and demo to know more about cell template option. Demo: https://ej2.syncfusion.com/aspnetcore/PivotTable/CellTemplate#/fluent Document : https://ej2.syncfusion.com/aspnetcore/documentation/pivot-table/row-and-column#cell-template
lkin in the chart control we can see a chart with multi series chart. is it possible to use it in Pivot control	We believe your requirement is to display the pivot chart series with multiple axes based on values bound in the pivot component. If this is the case, you can draw the pivot chart with multiple value fields by enabling the enableMultipleAxis property in the e-chartSettings tag. Please refer to the following code example.   Code Example:  <ejs-pivotview id="PivotView" height="500">    <e-chartSettings enableMultipleAxis="true">         <e-chartSeries type="Column"></e-chartSeries>     </e-chartSettings> </ejs-pivotview>   Output screenshot:   Meanwhile, we have prepared a sample for your reference. Please find it from the below attachment.   To know more about pivot chart, please refer the below documentation link. Document: https://ej2.syncfusion.com/aspnetcore/documentation/pivot-table/pivot-chart#multiple-axis

Please let us know if any concern occurs.

Regards,

Angelin Faith Sheeba.

Attachment: WebApplication2_83736ecc.zip

[ASIM TAUSIF KHAN]

Can you please check this link

https://ej2.syncfusion.com/aspnetcore/Chart/MultiSeriesChart#/bootstrap5

i want this result in my pivot table control.

[AngelinFaithSheeba PaulvannanRajadurai]

Hi Asim,

Yes, you can render multi series chart in the pivot table. In this below code example, the revenue growth of the solar energy is displayed as line chart series by using the chartSeriesCreated event.

Code Example:

function chartSeriesCreated(args){

       for (var i=0; i<args.series.length; i++){

            if (args.series[i].name == "Solar") {

                args.series[i].type = "Line";

            }

        }

    }

Output screenshot:

Meanwhile, we have prepared a sample for your reference. Please find it from the below attachment.

We hope that the above details would fulfill your need. Please let us know if any concern occurs.

Regards,

Angelin Faith Sheeba.

Attachment: WebApplication2_2cc9b668.zip