按堆积面积图Power Bi中的图例排序 [英] Sort on legend in Stacked Area Chart Power Bi

问题描述

我在Power BI上使用堆栈图，在图表中将Year用作x轴，将Group用作图例，并将Work Order％用作值.我也有组的排序顺序，但是很难根据组排序对图例进行排序.现在，传奇不是按排序顺序出现的.

I am using Stack chart on Power BI, I have used Year as x-axis, Group as legend in my graph and % of Work Order as value. I have Sort order of group as well but struggling to sort legends based on Group Sort. Now Legends are not coming in sort order.

推荐答案

只需执行以下步骤-

1. 转到 Model 窗口并选择表格
2. 现在选择您的列组
3. 最后，使用列 Group Short 对列进行排序，如下面的示例图片所示-

1. Go to the Model window and select the table
2. Now select your column Group
3. Finally, sort the column using column Group Short as shown in the sample image below-

这应该根据您的要求订购-

This should order as per your requirement-

这篇关于按堆积面积图Power Bi中的图例排序的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！