Progress Callout
(for use with tables, to use elsewhere remove the IF HASONEVALUE)
Adjust the svg width height and viewbox to fit text
Callout Progress =
--- Field to sort the measures by in a table ---
VAR SORT = DIVIDE(SUM(Projects[Consumed Budget]),SUM(Projects[Budget]))*100
--- Progress Bar Info ---
VAR PERCENTAGEFILL = Max(Projects[Progress %])*100
VAR BarColour = "Navy"
RETURN
IF(HASONEVALUE(Projects[Project]),
"data:image/svg+xml;utf8," &
"<svg desc = '" & SORT & "' width='100' height='30' viewBox='-2 -2 105 20' xmlns='http://www.w3.org/2000/svg' xmlns:xlink='http://www.w3.org/1999/xlink' display= 'block' overflow='visible'>
<rect id='track' x='0' y='15' rx='0' ry='0' width='100' height='10' fill='#D0D0D0' />
<rect id='fill' x='0' y='15' rx='0' ry='0' width="& "'"& PERCENTAGEFILL &"'"&" height='10' fill='"&BarColour&"'></rect>
<text x='0' y='8' font-weight='bold' font-family='Segoe UI, sans-serif' >"&FORMAT(PERCENTAGEFILL/100, "0%")&"</text>
</svg>"
, BLANK())
State Callout
State =
VAR Stage = MAX (Projects[Project Stage])
VAR Colour = SWITCH ( Stage,
"Execute", "Green",
"Ideate", "Orange",
"Plan", "Navy")
VAR Box = "<rect id='track' x='0' y='3' rx='10' ry='10' width='100' height='20' fill='"&Colour&"' stroke='#D0D0D0' stroke-width='0'></rect>"
VAR Callout = "<text x='5' y='18' fill='white' font-weight='bold' font-family='Segoe UI, sans-serif' >"&Stage&"</text>"
Return
IF(HASONEVALUE(Projects[Project]),
"data:image/svg+xml;utf8," &
"<svg width='100' height='30' viewBox='-2 -2 105 20' xmlns='http://www.w3.org/2000/svg' xmlns:xlink='http://www.w3.org/1999/xlink' display= 'block' overflow='visible'>"
& Box & Callout &
"</svg>"
, BLANK())
State Callout Variable Width Rectangle
State Variable Width Rectangle =
VAR Stage = MAX (Projects[Project Risk])
VAR BackgroundColour = SWITCH ( Stage,
"High", "Maroon",
"Medium", "Orange",
"Low", "Navy")
VAR FontColour = "white"
Return
IF(HASONEVALUE(Projects[Project]),
"data:image/svg+xml;utf8," &
"<svg width='100' height='30' viewBox='-2 -2 105 20' xmlns='http://www.w3.org/2000/svg' xmlns:xlink='http://www.w3.org/1999/xlink' display= 'block' overflow='visible'>"
&
"<defs>
<filter x='-0.1' y='-0.1' width='1.2' height='1.2' id='solid'>
<feFlood flood-color='"& BackgroundColour &"'/>
<feComposite in='SourceGraphic' operator='xor' />
</filter>
</defs>
<text filter='url(#solid)' x='5' y='18' fill='" & FontColour & "' font-weight='bold' font-family='Segoe UI, sans-serif' >" & Stage &" </text>" &
"</svg>"
, BLANK())
State Callout Variable Width Pill
State Variable Width =
VAR Stage = MAX (Projects[Project Risk])
VAR Width = (LEN(Stage)+1)*11
VAR Colour = SWITCH ( Stage,
"High", "Maroon",
"Medium", "Orange",
"Low", "Navy")
VAR Box = "<rect id='track' x='0' y='3' rx='10' ry='10' width='"&Width&"' height='20' fill='"&Colour&"' stroke='#D0D0D0' stroke-width='0'></rect>"
VAR Callout = "<text x='5' y='18' fill='white' font-weight='bold' font-family='Segoe UI, sans-serif' >"&Stage&"</text>"
Return
IF(HASONEVALUE(Projects[Project]),
"data:image/svg+xml;utf8," &
"<svg width='100' height='30' viewBox='-2 -2 105 20' xmlns='http://www.w3.org/2000/svg' xmlns:xlink='http://www.w3.org/1999/xlink' display= 'block' overflow='visible'>"
& Box & Callout &
"</svg>"
, BLANK())
genial, muchas gracias por compartir… Tengo una duda, cómo haces para que la categoría del proyecto no se repita por cada proyecto y solo te muestre una única vez?