Power BI 模拟麦肯锡华夫饼图

麦肯锡_华夫饼图 =
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 ), "Black", "LightGrey" ) & "' />"
    ) //生成100个圆
VAR Chart =
    "data:image/svg+xml;utf8," & "
    <svg xmlns='http://www.w3.org/2000/svg' width='150' height='150'>" & "
        <g transform='rotate(-90,75,75)'>"
            & CONCATENATEX ( tWaffle, [circle] ) & "
        </g>
    <!-- 数据标签-->
        <text x='70' y='20' font-size='15' text-anchor='middle' >"
            & ROUND ( [业绩达成率] * 100, 0 ) & "</text>
        <text x='70' y='148' font-size='15' text-anchor='middle' >"
            & SELECTEDVALUE ( '业绩表'[店铺] ) & "</text>
    </svg> "
RETURN
    IF ( HASONEVALUE ( '业绩表'[店铺] ), Chart, BLANK () )