Forum Discussion

wujunmin's avatar
wujunmin
Advocate III
4 years ago

Matrix Bubble Chart By DAX

Mark the measure as Image URL:

Chart = 
VAR MAXR=MAXX(ALL('table'),[data])
RETURN
"data: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> " 

 

1 Reply

  • 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