Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers!
Enter the sweepstakes now!Preparing for a certification exam? Ask exam experts all your questions on May 15th. Register now.
Mark the SVG measure below as image URL:
表格哑铃图 =
VAR MAX1 =
MAXX ( ALL ( 'table' ), [M.今年] )
VAR MAX2 =
MAXX ( ALL ( 'table' ), [M.去年] )
VAR W =
IF ( MAX1 >= MAX2, MAX1, MAX2)
VAR Value_Left= MIN ( [M.今年], [M.去年] )
VAR Value_Right=MAX ( [M.今年], [M.去年] )
VAR Color_Circle_Left=IF ( [M.今年] <= [M.去年], "DeepSkyBlue", "Black" )
VAR Color_Circle_Right=IF ( [M.今年] > [M.去年], "DeepSkyBlue", "Black")
VAR Line="<line x1='" & Value_Left / W*130+10 & "' y1='15' x2='" & Value_Right / W*130+10 & "' y2='15' style='stroke:DimGray;stroke-width:2' />"
VAR Circle_Left=
"<circle cx='" & Value_Left / W*130+10 & "' cy='15' r='5'" & " fill='" & Color_Circle_Left & "'/>"
VAR Circle_Right=
"<circle cx='" & Value_Right / W*130+10 & "' cy='15' r='5'" & " fill='" & Color_Circle_Right & "'/>"
VAR Bar =
Line& Circle_Left & Circle_Right
VAR SVG = "data:image/svg+xml;utf8," & "<svg xmlns='http://www.w3.org/2000/svg' height='30' width='150' >" & Bar & "</svg>"
RETURN
SVG
Check out the April 2025 Power BI update to learn about new features.
Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.