由于自带的华夫饼图，当某一分类大于100%时，其他分类会基于它计算
人工成本应该是136%
自定义华夫饼图
新建度量值，设置为图像URL并放入矩阵
华夫饼图 =
VAR t =
GENERATESERIES ( 1, 10 ) //1-10的序列
VAR tPlus =
GENERATE ( SELECTCOLUMNS ( t, "Value1", [Value] ), t ) //笛卡尔集
VAR tPlusPlus =
ADDCOLUMNS ( tPlus, "Index", RANKX ( tPlus, [Value] + [Value1] / 100,, ASC ) ) //生成1-100的序号
VAR tWaffle =
ADDCOLUMNS (
tPlusPlus,
"circle",
"<circle cx='" & [Value] * 10 + 15 & "' cy='" & [Value1] * 10 + 15 & "' r='4' fill='"
& IF ( [Index] <= ROUND ( [%] * 100, 0 ), "Orange", "LightGrey" ) & "' />" //可以自定义颜色
) //生成100个圆
VAR Chart =
"data:image/svg+xml;utf8," & "
<svg xmlns='http://www.w3.org/2000/svg' width='200' height='200'>" & "
<g transform='rotate(-90,75,75)'>"
& CONCATENATEX ( tWaffle, [circle] ) & "
</g>
<!-- 数据标签-->
<text x='70' y='20' font-size='14' text-anchor='middle' >"
& ROUND ( [%] * 100, 0 ) & "%</text>
<text x='70' y='148' font-size='14' text-anchor='middle' >"
& SELECTEDVALUE ( '分类'[L] ) & "</text>
</svg> "
RETURN
IF ( HASONEVALUE ( '分类'[L] ), Chart, BLANK () )
自定义华夫饼图
