【视频】Power BI 四象限划分

四象限方块图 = 
VAR X="增长率" //X轴名称
VAR Y="达成率" //Y轴名称
VAR data1=100//高达成高增长店铺数量，可替换为你的度量值
VAR data2=20//高达成低增长店铺数量，可替换为你的度量值
VAR data3=30//低达成高增长店铺数量，可替换为你的度量值
VAR data4=50//低达成低增长店铺数量，可替换为你的度量值
VAR W=MAX(MAX(data1,data2),MAX(data3,data4)) //最大面积是100*100的正方形
VAR SVG=
"data:image/svg+xml;utf8,<svg xmlns='http://www.w3.org/2000/svg' height='240' width='240'>
<polygon points='120,120 "&120+SQRT(data1/W*10000)&",120 "& 120+SQRT(data1/W*10000)&","&120-SQRT(data1/W*10000)&" 120,"&120-SQRT(data1/W*10000)&"' style='fill:OliveDrab' />"&IF(data1>0,
    "<text x='"&120+SQRT(data1/W*10000)/2&"' y='"&120-SQRT(data1/W*10000)/2&"' fill='black' text-anchor='Middle' font-size='12' >" & data1 & "</text>",BLANK()) &
//高达成高增长面积
    "<polygon points='120,120 "&120-SQRT(data2/W*10000)&",120 "& 120-SQRT(data2/W*10000)&","&120-SQRT(data2/W*10000)&" 120,"&120-SQRT(data2/W*10000)&"' style='fill:DarkGray' />"&IF(data2>0,
    "<text x='"&120-SQRT(data2/W*10000)/2&"' y='"&120-SQRT(data2/W*10000)/2&"' fill='black' text-anchor='Middle' font-size='12' >" & data2 & "</text>",BLANK()) &
//高达成低增长面积
    "<polygon points='120,120 "&120+SQRT(data3/W*10000)&",120 "& 120+SQRT(data3/W*10000)&","&120+SQRT(data3/W*10000)&" 120,"&120+SQRT(data3/W*10000)&"' style='fill:DimGray' />"&IF(data3>0,
"   <text x='"&120+SQRT(data3/W*10000)/2&"' y='"&120+SQRT(data3/W*10000)/2&"' fill='black' text-anchor='Middle' font-size='12' >" & data3 & "</text>",BLANK()) &
//低达成高增长面积
    "<polygon points='120,120 "&120-SQRT(data4/W*10000)&",120 "& 120-SQRT(data4/W*10000)&","&120+SQRT(data4/W*10000)&" 120,"&120+SQRT(data4/W*10000)&"' style='fill:Tomato' />"&IF(data4>0,
    "<text x='"&120-SQRT(data4/W*10000)/2&"' y='"&120+SQRT(data4/W*10000)/2&"' fill='black' text-anchor='Middle' font-size='12' >" & data4 & "</text>",BLANK())
//低达成低增长面积
&"
<line x1='0' y1='120' x2='240' y2='120' style='stroke:black;stroke-width:0.5' />
<line x1='120' y1='0' x2='120' y2='240' style='stroke:black;stroke-width:0.5' />
<line x1='235' y1='115' x2='240' y2='120' style='stroke:black;stroke-width:0.5' />
<line x1='240' y1='120' x2='235' y2='125' style='stroke:black;stroke-width:0.5' />
<line x1='115' y1='5' x2='120' y2='0' style='stroke:black;stroke-width:0.5' />
<line x1='120' y1='0' x2='125' y2='5' style='stroke:black;stroke-width:0.5' />
<text x='240' y='129' fill='black' text-anchor='end' font-size='8' >" & X & "</text>
<text x='127' y='8' fill='black' text-anchor='start' font-size='8' >" & Y & "</text>
</svg> "
Return SVG