Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowJuly 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss your chance! Learn more
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 () )
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.
Join Data Days 2026: 60 days of free live/on-demand sessions, challenges, study groups, and certification opportunities.