cancel
Showing results for 
Search instead for 
Did you mean: 
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
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors