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

July 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss your chance! Learn more

Reply
wujunmin
Advocate III
Advocate III

DIY Gradient Bar Chart by DAX+SVG

wujunmin_0-1632298769380.png

Measure: 

Bar = 
VAR CityCount =
    DISTINCTCOUNT ( 'table'[city] )
VAR Height =30
VAR MaxSales =
    MAXX ( ALLSELECTED('table'), [revenue] ) / 300
VAR Color=
"<defs>
    <LinearGradient id='wu'>
        <Stop offset='0%' style='stop-color:White'/>
        <Stop offset='100%' style='stop-color:DarkCyan'/>
    </LinearGradient>
</defs>"
VAR BarTable =
    ADDCOLUMNS (
        SUMMARIZE (
            'table',
            'table'[city],
            "index", RANKX ( ALLSELECTED ( 'table' ), [revenue],,, DENSE )
        ),
        "Rect",
            "<rect x='0' y='" & ( [index] - 1 ) * Height & "' width='" & [revenue] / MaxSales & "' height='" & Height-2 & " ' rx='15' ry='15' fill='url(#wu)' />",
        "Text",
            "<text x='2' y='"
                & ( [index] - 1 ) * Height
                    + INT ( Height * 0.6 ) & "' fill='black' text-anchor='left' font-size='"
                & INT ( Height * 0.6 ) & "' >" & [city] & "["
                & ROUND ( [revenue], 0 ) & "]" & "</text>"
    )
VAR Bar =
    CONCATENATEX ( BarTable, [Rect] & [Text] )
VAR SVG = "<svg xmlns='http://www.w3.org/2000/svg' height='"&Height*CityCount&"' width='300' >" &Color& Bar & "</svg>"
RETURN
    IF ( HASONEVALUE ( 'table'[province] ), SVG, BLANK () )

 

0 REPLIES 0

Helpful resources

Announcements
FabCon and SQLCon Barcelona 2026

FabCon & SQLCon – Barcelona 2026

Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.

60 days of Data Days Carousel

Data Days 2026

Join Data Days 2026: 60 days of free live/on-demand sessions, challenges, study groups, and certification opportunities.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.

Top Solution Authors