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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors