如何将Deneb分解树模板适配Power BI数据集实现营收层级展示

1. 数据源绑定替换 #

原模板基于JSON数据源，需调整为Power BI字段绑定：

• 绑定总营收度量值作为数值字段（确保是聚合后的度量值，避免重复计算）
• 按拆分顺序绑定你的层级维度字段（如区域、产品类别、客户等）

2. 复刻单根节点结构 #

要实现示例中首行单个"总营收"根节点的效果，在Deneb的Spec中添加根节点生成逻辑：

"transform": [
  // 生成总营收根节点
  {
    "calculate": "'总营收'",
    "as": "节点名称"
  },
  {
    "aggregate": [{"op": "sum", "field": "总营收", "as": "营收"}],
    "groupby": ["节点名称"]
  },
  {
    "calculate": "null",
    "as": "父节点"
  },
  // 合并子层级数据（以区域、产品类别为例，替换为你的实际维度）
  {
    "union": [
      {"data": "source"},
      // 第一层级：按区域拆分
      {
        "transform": [
          {"aggregate": [{"op": "sum", "field": "总营收", "as": "营收"}], "groupby": ["区域"]},
          {"calculate": "datum['区域']", "as": "节点名称"},
          {"calculate": "'总营收'", "as": "父节点"},
          {"sort": [{"field": "营收", "order": "descending"}]}
        ]
      },
      // 第二层级：按产品类别拆分（父节点为区域）
      {
        "transform": [
          {"aggregate": [{"op": "sum", "field": "总营收", "as": "营收"}], "groupby": ["区域", "产品类别"]},
          {"calculate": "datum['产品类别']", "as": "节点名称"},
          {"calculate": "datum['区域']", "as": "父节点"},
          {"sort": [{"field": "营收", "order": "descending"}]}
        ]
      }
    ]
  }
]

3. 全局降序排序配置 #

确保所有层级节点按营收从高到低排列，需在两处配置排序：

• 每个子层级的transform中添加{"sort": [{"field": "营收", "order": "descending"}]}（如上述代码片段所示）
• 在编码区对节点名称字段设置排序规则：

"encoding": {
  "y": {
    "field": "节点名称",
    "sort": {"field": "营收", "order": "descending"},
    "type": "ordinal"
  }
}

4. 完整适配后核心Spec示例 #

{
  "$schema": "https://vega.github.io/schema/vega-lite/v5.json",
  "data": {"name": "dataset"},
  "transform": [
    {
      "calculate": "'总营收'",
      "as": "节点名称"
    },
    {
      "aggregate": [{"op": "sum", "field": "总营收", "as": "营收"}],
      "groupby": ["节点名称"]
    },
    {
      "calculate": "null",
      "as": "父节点"
    },
    {
      "union": [
        {"data": "source"},
        {
          "transform": [
            {"aggregate": [{"op": "sum", "field": "总营收", "as": "营收"}], "groupby": ["区域"]},
            {"calculate": "datum['区域']", "as": "节点名称"},
            {"calculate": "'总营收'", "as": "父节点"},
            {"sort": [{"field": "营收", "order": "descending"}]}
          ]
        },
        {
          "transform": [
            {"aggregate": [{"op": "sum", "field": "总营收", "as": "营收"}], "groupby": ["区域", "产品类别"]},
            {"calculate": "datum['产品类别']", "as": "节点名称"},
            {"calculate": "datum['区域']", "as": "父节点"},
            {"sort": [{"field": "营收", "order": "descending"}]}
          ]
        }
      ]
    }
  ],
  "mark": {"type": "rect", "stroke": "#fff", "strokeWidth": 1},
  "encoding": {
    "y": {
      "field": "节点名称",
      "sort": {"field": "营收", "order": "descending"},
      "type": "ordinal",
      "title": null
    },
    "x": {
      "field": "父节点",
      "type": "ordinal",
      "title": null
    },
    "color": {
      "field": "营收",
      "type": "quantitative",
      "scale": {"scheme": "blues"},
      "title": "营收"
    },
    "tooltip": [
      {"field": "节点名称", "type": "nominal", "title": "节点"},
      {"field": "营收", "type": "quantitative", "title": "营收", "format": "$,.2f"}
    ]
  }
}

5. 关键注意事项 #

• 将示例中的区域、产品类别替换为你实际的层级维度字段
• 若需更多拆分层级，按相同逻辑在union中追加子层级的transform块
• 确保Power BI中已正确创建总营收度量值，避免原始字段的重复计算问题

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