Power BI Deneb/Vega-lite Y轴按数值字段排序失效问题

问题描述 #

尝试通过数据集的数值字段TaskTableSortLogic对Y轴的Tasks字段进行升序排序，但排序未生效。排序配置最初放在图层外的y编码通道中，后移入各图层内仍无效果，预期排序应在所有图层间共享。

完整Vega-Lite配置代码如下：

{
    "data": {
        "name": "dataset"
    },
    "transform": [
        {
            "calculate": "length(data('dataset'))",
            "as": "RowCount"
        },
        {
            "calculate": "datum.JTOSatUnSatCount / datum.JTOSatUnSatTotalCount",
            "as": "PercentageTextLabel"
        },
        {
            "calculate": "if(datum.GradeCategory === 'Repeat Unsat', '#F3667F', if(datum.GradeCategory === 'Unsat', '#C00000', if(datum.GradeCategory === 'Repeat Sat', '#638F00', if(datum.GradeCategory === 'Sat', '#00C800', '#000000'))))",
            "as": "GradeCategoryColorCode"
        },
        {
            "calculate": "if(datum.PercentageTextLabel >= 0.05, 1, 0)",
            "as": "PercentageTextLabelOpacity"
        },
        {
            "calculate": "'Total: ' + datum.JTOSatUnSatTotalCount",
            "as": "TotalTextLabel"
        }
    ],
    "height": {
        "step": 50
    },
    "padding": {
        "top": 0,
        "bottom": 0,
        "left": 0,
        "right": 80
    },
    "encoding": {
        "x": {
            "axis": {
                "labels": false,
                "title": "Distribution",
                "grid": false
            }
        },
        "y": {
            "field": "Tasks",
            "type": "nominal",
            "sort": {
                "field": "TaskTableSortLogic",
                "order": "ascending"
            },
            "axis": {
                "labelPadding": 20,
                "labelLimit": 600,
                "title": "Tasks",
                "titleX": -600,
                "titleY": {
                    "expr": "pbiContainer.scrollTop + pbiContainer.height / 2"
                }
            }
        }
    },
    "layer": [
        {
            "params": [
                {
                    "name": "hoverEffect",
                    "select": {
                        "type": "point",
                        "on": "pointerover"
                    }
                }
            ],
            "name": "Horizontal Stacked Bar Chart (bar mark)",
            "mark": {
                "type": "bar",
                "tooltip": true,
                "cursor": "pointer",
                "height": {
                    "expr": "if(datum.RowCount > 10, 28, 45)"
                },
                "stroke": {
                    "expr": "datum.GradeCategoryColorCode"
                }
            },
            "encoding": {
                "x": {
                    "field": "JTOSatUnSatCount",
                    "type": "quantitative",
                    "stack": "normalize"
                },
                "order": {
                    "field": "SatUnSatRepeatSort",
                    "sort": "ascending",
                    "type": "quantitative"
                },
                "color": {
                    "field": "GradeCategory",
                    "type": "nominal",
                    "legend": null,
                    "scale": {
                        "domain": [
                            "Repeat Unsat",
                            "Unsat",
                            "Repeat Sat",
                            "Sat"
                        ],
                        "range": [
                            "#F3667F",
                            "#C00000",
                            "#638F00",
                            "#00C800"
                        ]
                    }
                },
                "opacity": {
                    "condition": {
                        "param": "hoverEffect",
                        "empty": false,
                        "value": 0.7
                    },
                    "value": 1
                },
                "strokeWidth": {
                    "condition": {
                        "param": "hoverEffect",
                        "empty": false,
                        "value": 2
                    },
                    "value": 0
                }
            }
        },
        {
            "params": [
                {
                    "name": "TextHoverEffect",
                    "select": {
                        "type": "point",
                        "on": "pointerover"
                    }
                }
            ],
            "name": "Percentage Label (text mark)",
            "mark": {
                "type": "text",
                "baseline": "middle",
                "color": "white"
            },
            "encoding": {
                "text": {
                    "field": "PercentageTextLabel",
                    "type": "quantitative",
                    "format": ".0%"
                },
                "order": {
                    "field": "SatUnSatRepeatSort",
                    "type": "quantitative",
                    "sort": "ascending"
                },
                "x": {
                    "field": "PercentageTextLabel",
                    "type": "quantitative",
                    "stack": "normalize",
                    "bandPosition": 0.5
                },
                "opacity": {
                    "field": "PercentageTextLabelOpacity",
                    "type": "quantitative",
                    "scale": null
                },
                "size": {
                    "condition": {
                        "param": "TextHoverEffect",
                        "empty": false,
                        "value": 13
                    },
                    "value": 11
                }
            }
        },
        {
            "name": "Total Label (text mark)",
            "transform": [
                {
                    "aggregate": [
                        {
                            "op": "max",
                            "field": "TotalTextLabel",
                            "as": "UniqueTotalTextLabel"
                        }
                    ],
                    "groupby": [
                        "Tasks"
                    ]
                }
            ],
            "mark": {
                "type": "text",
                "baseline": "middle",
                "color": "black",
                "dx": 325,
                "fontWeight": "bold"
            },
            "encoding": {
                "text": {
                    "field": "UniqueTotalTextLabel",
                    "type": "nominal"
                }
            }
        }
    ]
}

问题根源 #

第三个图层（Total Label）的聚合转换仅按Tasks分组并保留TotalTextLabel，未包含TaskTableSortLogic字段。Vega-Lite渲染时，若某图层的数据集缺失排序字段，会导致全局排序逻辑失效——因为该图层的聚合数据集会成为布局基准，覆盖顶层的排序配置。

修复方案 #

1. 顶层统一聚合排序字段 #

在顶层transform数组开头添加聚合转换，提前按Tasks分组并保留TaskTableSortLogic（假设每个Tasks对应唯一的排序值），确保所有图层共享该字段：

{
    "aggregate": [
        {"op": "max", "field": "TaskTableSortLogic", "as": "TaskTableSortLogic"}
    ],
    "groupby": ["Tasks"]
}

2. 补全第三个图层的聚合字段 #

修改第三个图层的transform，在聚合操作中加入TaskTableSortLogic，保证该图层数据集包含排序字段：

{
    "aggregate": [
        {"op": "max", "field": "TotalTextLabel", "as": "UniqueTotalTextLabel"},
        {"op": "max", "field": "TaskTableSortLogic", "as": "TaskTableSortLogic"}
    ],
    "groupby": ["Tasks"]
}

3. 保留顶层排序配置 #

无需在各图层重复设置排序，顶层Y轴编码的排序配置会被所有图层继承：

"y": {
    "field": "Tasks",
    "type": "nominal",
    "sort": {
        "field": "TaskTableSortLogic",
        "order": "ascending"
    },
    // 其他轴配置...
}

完成以上修改后，Y轴即可按照TaskTableSortLogic字段正常升序排序。

内容的提问来源于stack exchange，提问作者trimakichan