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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
wujunmin
Advocate I
Advocate I

Dumbbell bar chart in table and matrix

Result:

wujunmin_1-1684291382294.png

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&colon;image/svg+xml;utf8," & "<svg xmlns='http://www.w3.org/2000/svg' height='30' width='150' >" & Bar  & "</svg>" 
RETURN
    SVG

 

 

0 REPLIES 0

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors