Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
wujunmin
Advocate I
Advocate I

Matrix Bubble Chart By DAX

wujunmin_0-1642476852733.png

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> " 

wujunmin_2-1642477000925.png

 

1 REPLY 1
robby1200
New Member

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

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors