Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Combine Table & Stacked Bar Chart

All,   I have a requirement to develop a report like below. Just removed the approver name due to security reason, think of some names under Approver.   This is not a single chart, i just a...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Yes, I Can see that option, but it looks like it will not fulfil my requirement.

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
6 years ago

OK this was what I was able to pull together. It's rough and needs work. I couldn't understand how the Age Group column factored in to this so I just kind of went with some data. I'll give you the code. It "works", it's not what I would call pretty. Attached a PBIX but you won't be able to open it unless you upgrade to April 2020.

SVG Stacked Data Bar = 
    VAR __Table = 'Table'
    VAR __Total = MAX('Table'[Average of Duration]) + MAX('Table'[count of projects])
    VAR __Color1 = IF(MAX('Table'[Average of Duration]) > MAX('Table'[count of projects]),"Red","Green")
    VAR __Color2 = IF(MAX('Table'[Average of Duration]) > MAX('Table'[count of projects]),"Green","Red")
    VAR __Min = MIN(MAX('Table'[Average of Duration]),MAX('Table'[count of projects]))
    VAR __ShapeWidth2 = __Min / __Total * 500
    VAR __header = "data:image/svg+xml;utf8," &
              "<svg xmlns='http://www.w3.org/2000/svg' x='0px' y='0px' width='" & "500" & "' height='210'>"
    VAR __footer = "</svg>"
    VAR __shapeTextSquare1 = "<polygon points=""0,200 " & "500" & ",200 " & "500" & ",0 0,0"" style=""fill:" & __Color1 & ";stroke:" & __Color1 & ";stroke-width:0;fill-rule:evenodd;"" />" 
    VAR __shapeTextSquare2 = "<polygon points=""0,200 " & __ShapeWidth2 & ",200 " & __ShapeWidth2 & ",0 0,0"" style=""fill:" & __Color2 & ";stroke:" & __Color2 & ";stroke-width:0;fill-rule:evenodd;"" />" 
    VAR __SVG = __header & __shapeTextSquare1 & __shapeTextSquare2 & __footer
RETURN
    __SVG