标签表达式适用于系列组，但不适用于类别组 [英] Label expression works on the series groups, but not on category groups

问题描述

在我正在构建的图表中，需要在显示之前转换系列和类别标签.转换很简单 - 用另一个字符替换一些字符并取左 X 个字符.进入系列组/常规/标签的属性，表达式工作正常.图例显示转换后的系列名称.我希望类别组也是如此，转换后的标签应该沿 X 轴显示.但这不起作用 - X 轴标签仍然是图表从中获取数据的底层矩阵的原始列名.在矩阵的列名上使用完全相同的表达式，效果很好.

In the chart I am building the series and categories labels need to be converted before displaying. Conversion is trivial - replacing some charater with another and taking left X characters. Entered into the properties of the Series groups/General/Label the expression works fine. The legend shows the converted series names. I expected that the same should be true for the categories groups and the converted labels should show along the X axis. But that is not working - the X axis labels are still raw column names from the underlying matrix where the chart takes data from. The exact same expression is used on the matrix's column names and that works fine.

=Left(Fields!fiscalmonth.Value, 3)

这会将我的 11 月转换为矩阵中的 11 月等，但不在图表轴 X 上.

That converts my November to Nov etc in the matrix, but not on the chart axis X.

推荐答案

更改 X 轴标签的正确位置是系列属性/类别字段表达式.这有点违反直觉，但有效.

The correct place for changing X axis labels is the Series Properties/Category Field expression. This is somewhat counter-intuitive, but works.

这篇关于标签表达式适用于系列组，但不适用于类别组的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！