Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
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 November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.