Matrix Bubble Chart By DAX

wujunmin · ‎01-17-2022

Mark the measure as Image URL：

Chart = 
VAR MAXR=MAXX(ALL('table'),[data])
RETURN
"data&colon;image/svg+xml;utf8,"&"
<svg xmlns='http://www.w3.org/2000/svg' height='100' width='100'>
    <line x1='0' y1='50' x2='100' y2='50' stroke='black' stroke-width='0.5' />
    <line x1='50' y1='0' x2='50' y2='100' stroke='black' stroke-width='0.5' />
    <circle cx='50' cy='50' r='"&40*[data]/MAXR &"' fill='"&IF([data]>100,"Darkcyan","Tomato")&"'/>
    <text x='50' y='50' font-size='20' text-anchor='middle' dominant-baseline='middle'>"&[data]&"</text>
</svg> "

robby1200 · ‎10-10-2022

Dear wujunmin,

this is exactly what I would need. However, i am a complete Power BI Newbi and my skills do not go beyond using standard visuals and data modelling. May I ask on how I can implement this in my report?

Thanks in advance