Can't rotate X axis label after set LabelRotation="45"

[Thinh]

Dear

I try to rotate x axis label as in attachment like this:

<PivotChartPrimaryXAxis ZoomFactor="1" LabelIntersectAction="PivotChartLabelIntersectAction.Rotate45" LabelRotation="45">
<PivotChartPrimaryXAxisFont Color="#FF0000"></PivotChartPrimaryXAxisFont>
</PivotChartPrimaryXAxis>

but X Axis label rotation does not change

Attachment: Pivot_Table_4205a7fa_3bfb8439.rar

[Rajeshkannah G]

Hi Thinh,

Sorry for the inconvenience. We could reproduce the issue, and we are currently validating this with our internal team and we will update you further details within today (August 8, 2023).

Please let us know if you have any concerns.

Regards,

Rajeshkannah Gopalakrishnan.

[Rajeshkannah G]

Hi Thinh,

We would like to let you know that the pivot chart will be displayed by default with multi-level labels as x-axis labels. However, currently we don’t have support for “LabelRotation” option to the multilevel labels, which only support the chart's x-axis label. You can do this by disabling the ShowMultiLevelLabels property to false in the PivotChartSetitng. Please refer to the code example below. Meanwhile, we're looking into the possibility of giving label rotation support for multi-level labels in the pivot table, and we will update further details by tomorrow. (Aug 9th 2023). We appreciate your patience until.

Furthermore, when disabling the multi-level labels, you can do drill operations by clicking the chart series and selecting the context menu option. However, currently we are experiencing a problem with drill functionality which is currently not working when running the pivot chart with OLAP data using the "DisplayOption.View.Chart" option. And we are investigating now with this problem with high priority. Until then, we suggest you use the pivot chart as primary view by setting “View” as “Both” and “Primary” as “Chart” in DisplayOption along with our toolbar UI.

Code Example

<SfPivotView TValue="ProductDetails" Width="800" Height="350">

    <PivotViewDisplayOption View=Syncfusion.Blazor.PivotView.View.Chart></PivotViewDisplayOption>

    <PivotChartSettings ShowMultiLevelLabels="false" Title="Sales Analysis">

        <PivotChartSeries Type=Syncfusion.Blazor.PivotView.ChartSeriesType.Column></PivotChartSeries>

         <PivotChartPrimaryXAxis LabelRotation="45"  >

                 <PivotChartPrimaryXAxisFont Color="red"></PivotChartPrimaryXAxisFont>

             </PivotChartPrimaryXAxis>

    </PivotChartSettings>

</SfPivotView>

 

Output Screenshot

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

Please let us know if you have any concerns.

Regards,

Rajeshkannah G

Attachment: BlazorServer_936ddfc9.zip

[AngelinFaithSheeba PaulvannanRajadurai]

Hi Thinh,

Thanks for the patience. We checked the possibility of providing label rotation support for multi-level labels to the pivot chart and we regret to inform you that it is currently not achievable due to limitations in the chart's current architecture. Moreover, the issue with “Drill functionality not working when running the pivot chart with OLAP data using the "DisplayOption.View.Chart" option” has now been fixed, and the fix for this issue will be included in our next weekly release which is scheduled to be rolled out by August 16^th, 2023.

We appreciate your patience until.

Regards,

Rajeshkannah Gopalakrishnan

[Rajeshkannah G]

Hi Thinh,

We are glad to announce that our weekly Release V22.2.9 is rolled out and the fix for the issue “Drill functionality not working when running the pivot chart with OLAP data using the "DisplayOption.View.Chart" option” has been included in this release. Meanwhile, we have prepared a sample for your reference, please find it in the attachments.

Output screenshot:

Please let us know if you have any concerns.

Regards,

Rajeshkannah Gopalakrishnan.

Attachment: BlazorServer_11f9ca0.zip