Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. 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